Tamas Vincze (vincze@neb.com) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
INTERSECT fails
Long Description
I've used INTERSECT to get the common rows in 3 simple SELECTs.
If I write the query without grouping parentheses, PG reports 0 rows
which is incorrect. If I use parentheses to group the last two
SELECTs then it gives a better answer. If I reorder the SELECTs
then it gives another different answer. (see examples)
The result should be independent of the order and grouping of
the SELECTs, so I think it's a serious bug.
I use version 7.1.2 on solaris/sparc.
Sample Code
sites=# select recseq from frags where len>2222 and len<2406
sites-# intersect select recseq from frags where len>1503 and len<1627
sites-# intersect select recseq from frags where len>752 and len<814;
recseq
--------
(0 rows)
sites=# select recseq from frags where len>2222 and len<2406
sites-# intersect (select recseq from frags where len>1503 and len<1627
sites(# intersect select recseq from frags where len>752 and len<814);
recseq
--------
CACTG
CAGTG
CASTG
RGCGCY
YAACCT
(5 rows)
sites=# select recseq from frags where len>1503 and len<1627
sites-# intersect select recseq from frags where len>752 and len<814
sites-# intersect select recseq from frags where len>2222 and len<2406;
recseq
--------
CACTG
CAGTG
RGCGCY
YAACCT
(4 rows)
No file was uploaded with this report