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

Re: BUG #3459: Query Error : plan should not reference subplan's variable

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Sanchez i Gregori" <delkos_2000(at)yahoo(dot)es>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3459: Query Error : plan should not reference subplan's variable
Date: 2007-07-17 20:33:22
Message-ID: 5699.1184704402@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"David Sanchez i Gregori" <delkos_2000(at)yahoo(dot)es> writes:
> select * from(
> select min("ID") as nid from "Seguretat"."Usuarios" as j
> where not exists
> ( select 1 from "Seguretat"."Usuarios" as k where k."ID"=j."ID")
> ) as b

Confirmed here, as far back as 8.1.  It sort of looks like the
indexes-for-min-and-max patch has confused the older code for Param
assignment.  I'm surprised this wasn't reported earlier...

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2007-07-18 00:40:36
Subject: Re: BUG #3431: age() gets the days wrong
Previous:From: David Sanchez i GregoriDate: 2007-07-17 19:27:32
Subject: BUG #3459: Query Error : plan should not reference subplan's variable

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