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

On Fri, Apr 3, 2009 at 2:10 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
> Roman Kononov wrote:
>
>> Description:        hash join and sort-merge join make different results
>> Details:
>>
>> test-std=# create table t(s int,i interval);
>> CREATE TABLE
>> test-std=# insert into t values (0,'30 days'), (1,'1 month');
>> INSERT 0 2
>> test-std=# select * from t as a, t as b where a.i=b.i;
>
> Reproducible in 8.2.13 as well ..
>

and the same in HEAD

PS: the analyze not always brings the problems, i had to turn off
enable_mergejoin and enable_nestloop

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157