Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.


Attachment: nestloopparams.sql
Description: text/plain (3.4 KB)

In response to


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group