Changeset: 48165fb03ffb for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=48165fb03ffb Modified Files: sql/src/test/bugs/Tests/except-union-intersect-bug-sf-1146079.stable.out Branch: Oct2010 Log Message:
approved new output column width diffs (79 lines): diff -r 9177895f6260 -r 48165fb03ffb 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 Sat Oct 30 11:06:56 2010 +0200 +++ b/sql/src/test/bugs/Tests/except-union-intersect-bug-sf-1146079.stable.out Sat Oct 30 11:34:31 2010 +0200 @@ -318,25 +318,25 @@ Operation successful SELECT class FROM a EXCEPT ALL SELECT 16 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 | -+--------+ ++-------+ +| 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 ORDER BY class; -- all plus 16 @@ -397,18 +397,18 @@ 8 rows SELECT class FROM a EXCEPT ALL SELECT class FROM b 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 | -+--------+ ++-------+ +| class | ++=======+ +| 11 | +| 16 | +| 16 | +| 16 | +| 16 | +| 16 | +| 18 | +| 18 | ++-------+ 8 rows SELECT * FROM a UNION ALL SELECT * FROM b ORDER BY class, property; -- a + b _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
