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

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)

Responses

Browse pgsql-bugs by date

  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