Changeset: b432afbb534c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b432afbb534c
Added Files:
sql/test/Tests/union-corresponding.test
Modified Files:
sql/test/Tests/All
Branch: default
Log Message:
Adds tests for union corresponding
diffs (140 lines):
diff --git a/sql/test/Tests/All b/sql/test/Tests/All
--- a/sql/test/Tests/All
+++ b/sql/test/Tests/All
@@ -141,6 +141,7 @@ meltdown
savepoints1
savepoints2
union
+union-corresponding
## Queries from the old AS3AP benchmark.
## Since we don't have the data, let's just execute the queries here
as3ap
diff --git a/sql/test/Tests/union-corresponding.test
b/sql/test/Tests/union-corresponding.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/union-corresponding.test
@@ -0,0 +1,124 @@
+statement ok
+create table foo (a int, b text)
+
+statement ok
+insert into foo values
+ (1, 'alice'),
+ (2, 'bob')
+
+statement ok
+create table bar (c text, a int)
+
+statement ok
+insert into bar values
+ ('hello', 3),
+ ('world', 4)
+
+statement ok
+create table buz (a int, c text)
+
+statement ok
+insert into buz values
+ (5, 'one'),
+ (6, 'two')
+
+statement ok
+create table empty_a (a int, c text)
+
+statement ok
+create table empty_b (c int, a text)
+
+query I rowsort
+SELECT * FROM foo
+UNION CORRESPONDING
+SELECT * FROM bar
+----
+1
+2
+3
+4
+
+query IT rowsort
+SELECT * FROM foo
+UNION
+SELECT * FROM buz
+----
+1
+alice
+2
+bob
+5
+one
+6
+two
+
+query I rowsort
+SELECT * FROM foo
+UNION CORRESPONDING
+SELECT * FROM buz
+----
+1
+2
+5
+6
+
+query I rowsort
+SELECT a FROM foo
+NATURAL FULL JOIN buz
+----
+1
+2
+5
+6
+
+statement error
+SELECT * FROM foo
+UNION
+SELECT * FROM bar
+UNION
+SELECT * FROM buz
+
+query I rowsort
+SELECT * FROM foo
+UNION CORRESPONDING
+SELECT * FROM bar
+UNION CORRESPONDING
+SELECT * FROM buz
+----
+1
+2
+3
+4
+5
+6
+
+statement error
+SELECT * FROM buz
+UNION
+SELECT * FROM bar
+
+query IT rowsort
+SELECT * FROM buz
+UNION CORRESPONDING
+SELECT * FROM bar
+----
+3
+hello
+4
+world
+5
+one
+6
+two
+
+query I rowsort
+SELECT * FROM buz
+UNION CORRESPONDING BY (a)
+SELECT * FROM bar
+----
+3
+4
+5
+6
+
+
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
