Changeset: 29030533743e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/29030533743e
Modified Files:
sql/test/Tests/union-corresponding.test
Branch: default
Log Message:
Changes the table values of the union corresponding test
diffs (217 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
@@ -4,7 +4,8 @@ create table foo (a int, b text)
statement ok
insert into foo values
(1, 'alice'),
- (2, 'bob')
+ (2, 'bob'),
+ (9, null)
statement ok
create table bar (c text, a int)
@@ -12,7 +13,8 @@ create table bar (c text, a int)
statement ok
insert into bar values
('hello', 3),
- ('world', 4)
+ ('world', 4),
+ (null, 9)
statement ok
create table buz (a int, c text)
@@ -28,16 +30,6 @@ 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
@@ -51,6 +43,24 @@ 5
one
6
two
+9
+NULL
+
+query IT rowsort
+SELECT * FROM foo
+UNION ALL
+SELECT * FROM buz
+----
+1
+alice
+2
+bob
+5
+one
+6
+two
+9
+NULL
query I rowsort
SELECT * FROM foo
@@ -61,6 +71,18 @@ 1
2
5
6
+9
+
+query I rowsort
+SELECT * FROM foo
+UNION ALL CORRESPONDING
+SELECT * FROM buz
+----
+1
+2
+5
+6
+9
query I rowsort
SELECT a FROM foo
@@ -70,6 +92,7 @@ 1
2
5
6
+9
statement error
SELECT * FROM foo
@@ -91,6 +114,7 @@ 3
4
5
6
+9
statement error
SELECT * FROM buz
@@ -110,6 +134,8 @@ 5
one
6
two
+9
+NULL
query I rowsort
SELECT * FROM buz
@@ -121,6 +147,7 @@ 3
4
5
6
+9
query I rowsort
SELECT * FROM foo
@@ -131,6 +158,19 @@ 1
2
3
4
+9
+
+query I rowsort
+SELECT * FROM foo
+UNION ALL CORRESPONDING
+SELECT * FROM bar
+----
+1
+2
+3
+4
+9
+9
query I rowsort
SELECT * FROM foo
@@ -142,6 +182,7 @@ 1
2
3
4
+9
statement error
SELECT * FROM foo
@@ -172,6 +213,33 @@ hello
4
NULL
world
+9
+NULL
+NULL
+
+query ITT rowsort
+SELECT * FROM foo
+OUTER UNION ALL CORRESPONDING
+SELECT * FROM bar
+----
+1
+alice
+NULL
+2
+bob
+NULL
+3
+NULL
+hello
+4
+NULL
+world
+9
+NULL
+NULL
+9
+NULL
+NULL
query T rowsort
SELECT * FROM foo
@@ -191,6 +259,8 @@ SELECT * FROM bar
----
NULL
NULL
+NULL
+NULL
alice
bob
@@ -212,6 +282,8 @@ SELECT * FROM bar
----
NULL
NULL
+NULL
+NULL
hello
world
@@ -222,6 +294,8 @@ OUTER UNION
SELECT * FROM bar
----
NULL
+NULL
+NULL
alice
NULL
bob
@@ -237,6 +311,10 @@ OUTER UNION ALL
SELECT * FROM bar
----
NULL
+NULL
+NULL
+NULL
+NULL
alice
NULL
bob
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
