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

2013-04-25 Thread Andres Freund
On 2013-04-25 16:27:47 +0800, Jov wrote: > I can reproduce on 9.2.4 too. > > plan, but also wrong plan. I think it is a terrible bug. * Just in case you missed it, there's ongoing work to fix it. For some explanations see: http://www.postgresql.org/message-id/6546.1365701...@sss.pgh.pa.us Gree

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

2013-04-09 Thread Dickson S. Guedes
2013/4/9 : > 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

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

2013-04-09 Thread Dickson S. Guedes
2013/4/9 : > The following bug has been logged on the website: > > Bug reference: 8049 > Logged by: Teun Hoogendoorn > Email address: t...@atsc.nl > PostgreSQL version: 9.2.4 > Operating system: CentOS 6.3 final 64bit > Description: > > Hi, > > I've got a strange problem with