Re: BUG #4748: hash join and sort-merge join make different results - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4748: hash join and sort-merge join make different results
Date
Msg-id 21648.1238789905@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4748: hash join and sort-merge join make different results  ("Dickson S. Guedes" <listas@guedesoft.net>)
List pgsql-bugs
"Dickson S. Guedes" <listas@guedesoft.net> writes:
> I could reproduce this once in a database that already have a table
> named "t", then after i did dropped it i couldn't anymore.

As noted, you might have to force use of a hash join (my machine
preferred a mergejoin before the ANALYZE and a nestloop after).
It's definitely broken :-(

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Dickson S. Guedes"
Date:
Subject: Re: BUG #4748: hash join and sort-merge join make different results
Next
From: Roman Kononov
Date:
Subject: Re: BUG #4748: hash join and sort-merge join make different results