UNION discards indentical rows in postgres 7.3.3

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

Responses

Browse pgsql-bugs by date

  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