Changeset: c15f96310f33 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c15f96310f33 Modified Files: sql/test/2024/Tests/distinct_from.test Branch: distinct_from Log Message:
add test for two columns diffs (75 lines): diff --git a/sql/test/2024/Tests/distinct_from.test b/sql/test/2024/Tests/distinct_from.test --- a/sql/test/2024/Tests/distinct_from.test +++ b/sql/test/2024/Tests/distinct_from.test @@ -1,6 +1,3 @@ -statement ok -create table foo(s) as values (10), (20), (NULL) - query I nosort SELECT 10 IS NOT DISTINCT FROM 20 @@ -43,6 +40,9 @@ SELECT NULL IS NOT DISTINCT FROM NULL ---- 1 +statement ok +create table foo(s) as values (10), (20), (NULL) + query I nosort select s IS NOT DISTINCT FROM 20 FROM foo; ---- @@ -71,7 +71,6 @@ 1 1 0 - query I nosort select 20 IS NOT DISTINCT FROM s FROM foo; ---- @@ -99,3 +98,46 @@ select NULL IS DISTINCT FROM s FROM foo; 1 1 0 + +statement ok +create table bar(s) as values (20), (30), (NULL) + +query IIII rowsort +select foo.s, bar.s, foo.s IS DISTINCT FROM bar.s, foo.s IS NOT DISTINCT FROM bar.s FROM foo, bar +---- +10 +20 +1 +0 +10 +30 +1 +0 +10 +NULL +1 +0 +20 +20 +0 +1 +20 +30 +1 +0 +20 +NULL +1 +0 +NULL +20 +1 +0 +NULL +30 +1 +0 +NULL +NULL +0 +1 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org