Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4290: wrong double subselect with aggregate function - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4290: wrong double subselect with aggregate function
Date
Msg-id 21460.1215621734@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4290: wrong double subselect with aggregate function  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: BUG #4290: wrong double subselect with aggregate function
List pgsql-bugs
Tree view 
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Andreas wrote:
>> I expected for min_c_id in the second row 3.

> Which it is if you turn enable_indexscan to off ...

I think one of the subplans isn't getting re-evaluated when it should
be, which would be a botch in the extParam/parParam signaling.  Not sure
yet if it's a planner or executor bug, but more likely the former.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #4290: wrong double subselect with aggregate function
Next
From: Tom Lane
Date:
Subject: Re: BUG #4290: wrong double subselect with aggregate function