Re: [sqlsmith] subplan variable reference / unassigned NestLoopParams

From: Andreas Seltenreich <seltenreich(at)gmx(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [sqlsmith] subplan variable reference / unassigned NestLoopParams
Date: 2015-08-08 14:27:52
Message-ID: 8737ztua6v.fsf@ex.ansel.ydns.eu
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

Tom Lane writes:

> Andreas Seltenreich <seltenreich(at)gmx(dot)de> writes:
>> Tom Lane writes:
>>> Well, I certainly think all of these represent bugs:
>>>> 3 | ERROR: plan should not reference subplan's variable
>>>> 2 | ERROR: failed to assign all NestLoopParams to plan nodes
>
>> These appear to be related. The following query produces the former,
>> but if you replace the very last reference of provider with the literal
>> 'bar', it raises the latter error.
>
> Fixed that, thanks for the test case!

I haven't seen the former since your commit, but there recently were
some instances of the latter. The attached queries all throw the error
against master at 8752bbb.

regards,
Andreas

Attachment Content-Type Size
nestloopparams.sql text/plain 3.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2015-08-08 15:01:15 Re: WIP: SCRAM authentication
Previous Message Robert Haas 2015-08-08 14:16:23 Re: Dependency between bgw_notify_pid and bgw_flags