From: | Silvio Scarpati <silvio(dot)scarpati(at)virgilio(dot)it> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | UNION discards indentical rows in postgres 7.3.3 |
Date: | 2003-08-07 21:08:54 |
Message-ID: | 6rsyPxMhIPNgYKMTRn8tDUVCtCP8@4ax.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi Tom,
this seems a serious bug:
testdb=>
testdb=> create table t1(a int, b text);
CREATE TABLE
testdb=> create table t2(a int, b text);
CREATE TABLE
testdb=> insert into t1 values(1,'pippo');
INSERT 7591667 1
testdb=> insert into t1 values(2,'pluto');
INSERT 7591668 1
testdb=> insert into t2 values(3,'paperino');
INSERT 7591669 1
testdb=> insert into t2 values(3,'paperino');
INSERT 7591670 1
select a,b from t1 union (select a,b from t2);
a | b
---+----------
1 | pippo
2 | pluto
3 | paperino
(3 rows)
Wrong ! The query should return 4 rows. In other words i don't know
why postgres performs the following query:
select a,b from t1 union (select DISTINCT a,b from t2);
instead of the required one.
I think i's a bug.
Thank you.
Silvio Scarpati
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2003-08-07 21:15:19 | Re: UNION discards indentical rows in postgres 7.3.3 |
Previous Message | Marc G. Fournier | 2003-08-07 17:49:43 | Testing gateway |