Re: BUG #8049: Incorrect results when using ORDER BY and query planner options

From: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
To: th(at)atsc(dot)nl
Cc: pgsql-bugs(at)postgresql(dot)org, pg-dev <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: BUG #8049: Incorrect results when using ORDER BY and query planner options
Date: 2013-04-10 01:25:22
Message-ID: CAHHcreq9KzmG=Tc0NSNc0YUYV2jKq0OCsNmnz8YDdKZ=U599nA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

2013/4/9 <th(at)atsc(dot)nl>:
> I've got a strange problem with a query that produces more results than
> expected.

I tested this [1] and saw that 9.1 don't has the behavior then I
started bisect from REL9_1_9 to HEAD and found that commit 5b7b5518d0e
[2] introduced it.

I'm putting a copy to -hacker list in a hope that this help some one
with more experience on that code to go further.

[1] http://www.postgresql.org/message-id/CAHHcrepFavBPnTSE9Ho3=8FgXH8ciR7byKyMGMbdDfLdpWfzng@mail.gmail.com
[2] http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=5b7b5518d0ea56c422a197875f7efa5deddbb388

[]s
--
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message knowzerox 2013-04-10 02:02:08 BUG #8056: postgres forgets hstore over time
Previous Message Dickson S. Guedes 2013-04-09 23:03:53 Re: BUG #8049: Incorrect results when using ORDER BY and query planner options

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2013-04-10 01:36:55 Re: Enabling Checksums
Previous Message Robert Haas 2013-04-09 23:49:51 lwlock contention with SSI