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

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

--=20
Atentamente,
Jaime Casanova
Soporte y capacitaci=F3n de PostgreSQL
Asesor=EDa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157