Re: BUG #4290: wrong double subselect with aggregate function

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Andreas <postgresql(at)elbrief(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4290: wrong double subselect with aggregate function
Date: 2008-07-09 16:06:46
Message-ID: 20080709160646.GE3946@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Andreas wrote:

> min_c_id | b_aid | min_c_id_1 | min_c_id_2
> ----------+-------+------------+------------
> 1 | 1 | 1 | 3
> 1 | 2 | 1 | 3
>
> I expected for min_c_id in the second row 3.

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

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-07-09 16:42:14 Re: BUG #4290: wrong double subselect with aggregate function
Previous Message Andreas 2008-07-09 15:42:24 BUG #4290: wrong double subselect with aggregate function