Re: BUG #4748: hash join and sort-merge join make different results

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4748: hash join and sort-merge join make different results
Дата
Msg-id 21648.1238789905@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #4748: hash join and sort-merge join make different results  ("Dickson S. Guedes" <listas@guedesoft.net>)
Список 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 по дате отправления:

Предыдущее
От: "Dickson S. Guedes"
Дата:
Сообщение: Re: BUG #4748: hash join and sort-merge join make different results
Следующее
От: Roman Kononov
Дата:
Сообщение: Re: BUG #4748: hash join and sort-merge join make different results