From: | "Roman Kononov" <kononov(at)ftml(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4748: hash join and sort-merge join make different results |
Date: | 2009-04-03 19:07:46 |
Message-ID: | 200904031907.n33J7ktn030791@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4748
Logged by: Roman Kononov
Email address: kononov(at)ftml(dot)net
PostgreSQL version: 8.3.7
Operating system: GNU/Linux x86_64
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;
s | i | s | i
---+---------+---+---------
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 rows)
test-std=# analyze;
ANALYZE
test-std=# select * from t as a, t as b where a.i=b.i;
s | i | s | i
---+---------+---+---------
0 | 30 days | 0 | 30 days
1 | 1 mon | 1 | 1 mon
(2 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-04-03 19:10:13 | Re: BUG #4748: hash join and sort-merge join make different results |
Previous Message | Josh Berkus | 2009-04-03 16:35:43 | Re: MD5 checksum or RPM for PostgreSQL 8.7.3 |