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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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