Re: BUG #8287: select distinct / select group by - Invalid result

From: lindebg <lindebg(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8287: select distinct / select group by - Invalid result
Date: 2013-07-06 22:44:18
Message-ID: 51D89DC2.1050008@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

W dniu 2013-07-06 23:22, Tom Lane pisze:
> lindebg(at)gmail(dot)com writes:
>> I wanted to report an incorrect execution of the query SELECT DISTINCT... :
> FWIW, this example doesn't seem to misbehave for me in HEAD or 9.2
> branch tip. I suspect that this is a variant of bug #8049, which was
> fixed recently. It could be though that you're reporting some other
> problem but there are special circumstances (such as nondefault planner
> settings) needed to make it manifest. You could try applying this patch
> to see if the problem goes away for you:
>
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=841c9b6ba151ed5a41733ec345bf9bf32a55f4dc
>
> regards, tom lane

Thank you for your response. This problem does not exist in the branch
REL9_2_STABLE.

Regards, Jacek

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Евгений Кузнецов 2013-07-08 18:54:36 yum repository
Previous Message Tom Lane 2013-07-06 21:22:14 Re: BUG #8287: select distinct / select group by - Invalid result