Changeset: eca366a838af for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eca366a838af Modified Files: Branch: default Log Message:
merge with Jun2010 diffs (104 lines): diff -r 833dda1332e3 -r eca366a838af sql/src/test/bugs/Tests/except-union-intersect-bug-sf-1146079.stable.out --- a/sql/src/test/bugs/Tests/except-union-intersect-bug-sf-1146079.stable.out Mon Jul 12 22:04:34 2010 +0200 +++ b/sql/src/test/bugs/Tests/except-union-intersect-bug-sf-1146079.stable.out Mon Jul 12 23:28:10 2010 +0200 @@ -317,26 +317,26 @@ START TRANSACTION; Operation successful -SELECT class FROM a EXCEPT ALL SELECT 16; -- all but one 16 (will have 16 in output!) -+-------+ -| class | -+=======+ -| 17 | -| 17 | -| 17 | -| 17 | -| 2 | -| 11 | -| 18 | -| 18 | -| 16 | -| 16 | -| 16 | -| 16 | -| 16 | -| 16 | -| 16 | -+-------+ +select * from ( SELECT class FROM a EXCEPT ALL SELECT 16 ) as t order by class; -- all but one 16 (will have 16 in output!) ++--------+ +| class | ++========+ +| 2 | +| 11 | +| 16 | +| 16 | +| 16 | +| 16 | +| 16 | +| 16 | +| 16 | +| 17 | +| 17 | +| 17 | +| 17 | +| 18 | +| 18 | ++--------+ 15 rows SELECT class FROM a UNION ALL SELECT 16; -- all plus 16 @@ -396,19 +396,19 @@ +----------+-------+ 8 rows -SELECT class FROM a EXCEPT ALL SELECT class FROM b; -- a minus the elements from b that are in a (if count(x) in a > count(x) in b, x will appear in output) -+-------+ -| class | -+=======+ -| 11 | -| 18 | -| 18 | -| 16 | -| 16 | -| 16 | -| 16 | -| 16 | -+-------+ +select * from ( SELECT class FROM a EXCEPT ALL SELECT class FROM b ) as t order by class; -- a minus the elements from b that are in a (if count(x) in a > count(x) in b, x will appear in output) ++--------+ +| class | ++========+ +| 11 | +| 16 | +| 16 | +| 16 | +| 16 | +| 16 | +| 18 | +| 18 | ++--------+ 8 rows SELECT * FROM a UNION ALL SELECT * FROM b; -- a + b diff -r 833dda1332e3 -r eca366a838af sql/src/test/bugs/except-union-intersect-bug-sf-1146079.sql --- a/sql/src/test/bugs/except-union-intersect-bug-sf-1146079.sql Mon Jul 12 22:04:34 2010 +0200 +++ b/sql/src/test/bugs/except-union-intersect-bug-sf-1146079.sql Mon Jul 12 23:28:10 2010 +0200 @@ -73,7 +73,7 @@ -- now check the non-duplicate removing versions -- (they are very tricky, so be on your marks!) START TRANSACTION; -SELECT class FROM a EXCEPT ALL SELECT 16; -- all but one 16 (will have 16 in output!) +select * from ( SELECT class FROM a EXCEPT ALL SELECT 16 ) as t order by class; -- all but one 16 (will have 16 in output!) SELECT class FROM a UNION ALL SELECT 16; -- all plus 16 SELECT class FROM a INTERSECT ALL SELECT 16; -- just one 16 (!) ROLLBACK; @@ -83,7 +83,7 @@ -- would never be tested for tables) START TRANSACTION; SELECT * FROM a EXCEPT ALL SELECT * FROM b; -- last 50% of a -SELECT class FROM a EXCEPT ALL SELECT class FROM b; -- a minus the elements from b that are in a (if count(x) in a > count(x) in b, x will appear in output) +select * from ( SELECT class FROM a EXCEPT ALL SELECT class FROM b ) as t order by class; -- a minus the elements from b that are in a (if count(x) in a > count(x) in b, x will appear in output) SELECT * FROM a UNION ALL SELECT * FROM b; -- a + b SELECT * FROM a INTERSECT ALL SELECT * FROM b; -- first 50% of a SELECT class FROM a INTERSECT ALL SELECT class FROM b; -- only those that are both in a and b (min(count(a, x), count(b, x)) !!! _______________________________________________ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
