Changeset: adb2e07dfbf8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/adb2e07dfbf8 Modified Files: sql/test/Tests/union-corresponding.test Branch: default Log Message:
Adds more tests for union corresponding (OUTER and ALL variations) diffs (140 lines): diff --git a/sql/test/Tests/union-corresponding.test b/sql/test/Tests/union-corresponding.test --- a/sql/test/Tests/union-corresponding.test +++ b/sql/test/Tests/union-corresponding.test @@ -113,7 +113,8 @@ two query I rowsort SELECT * FROM buz -UNION CORRESPONDING BY (a) +UNION + CORRESPONDING BY (a) SELECT * FROM bar ---- 3 @@ -121,4 +122,126 @@ 4 5 6 +query I rowsort +SELECT * FROM foo +UNION CORRESPONDING +SELECT * FROM bar +---- +1 +2 +3 +4 +query I rowsort +SELECT * FROM foo +UNION + CORRESPONDING BY (a) +SELECT * FROM bar +---- +1 +2 +3 +4 + +statement error +SELECT * FROM foo +UNION + CORRESPONDING BY (b) +SELECT * FROM bar + +statement error +SELECT * FROM foo +UNION + CORRESPONDING BY (c) +SELECT * FROM bar + +query ITT rowsort +SELECT * FROM foo +OUTER UNION CORRESPONDING +SELECT * FROM bar +---- +1 +alice +NULL +2 +bob +NULL +3 +NULL +hello +4 +NULL +world + +query T rowsort +SELECT * FROM foo +OUTER UNION + CORRESPONDING BY (b) +SELECT * FROM bar +---- +NULL +alice +bob + +query T rowsort +SELECT * FROM foo +OUTER UNION ALL + CORRESPONDING BY (b) +SELECT * FROM bar +---- +NULL +NULL +alice +bob + +query T rowsort +SELECT * FROM foo +OUTER UNION + CORRESPONDING BY (c) +SELECT * FROM bar +---- +NULL +hello +world + +query T rowsort +SELECT * FROM foo +OUTER UNION ALL + CORRESPONDING BY (c) +SELECT * FROM bar +---- +NULL +NULL +hello +world + +query TT rowsort +SELECT * FROM foo +OUTER UNION + CORRESPONDING BY (c, b) +SELECT * FROM bar +---- +NULL +alice +NULL +bob +hello +NULL +world +NULL + +query TT rowsort +SELECT * FROM foo +OUTER UNION ALL + CORRESPONDING BY (c, b) +SELECT * FROM bar +---- +NULL +alice +NULL +bob +hello +NULL +world +NULL + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
