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

Em Sex, 2009-04-03 =E0s 15:10 -0400, Alvaro Herrera escreveu:
> Roman Kononov wrote:
>=20
> > Description:        hash join and sort-merge join make different results
> > Details:=20
> >=20
> > 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;
>=20
> Reproducible in 8.2.13 as well ..

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.

I'm using 8.3.7.

# create table tt_01(s int,i interval);
CREATE TABLE

# insert into tt_01 values (0,'30 days'), (1,'1 month');
INSERT 0 2

# select * from tt_01 as a, tt_01 as b where a.i=3Db.i;
 s |    i    | s |    i=20=20=20=20
---+---------+---+---------
 0 | 30 days | 0 | 30 days
 0 | 30 days | 1 | 1 mon
 1 | 1 mon   | 0 | 30 days
 1 | 1 mon   | 1 | 1 mon
(4 registros)

# ANALYZE ;
ANALYZE

# select * from tt_01 as a, tt_01 as b where a.i=3Db.i;
 s |    i    | s |    i=20=20=20=20
---+---------+---+---------
 0 | 30 days | 0 | 30 days
 0 | 30 days | 1 | 1 mon
 1 | 1 mon   | 0 | 30 days
 1 | 1 mon   | 1 | 1 mon
(4 registros)


--=20
Dickson S. Guedes=20
mail/xmpp: guedes@guedesoft.net - skype: guediz
http://guedesoft.net - http://planeta.postgresql.org.br