Changeset: 698ca3ec98dc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/698ca3ec98dc
Modified Files:
sql/test/sys-schema/Tests/webExamplesLogicalFunctionsOperators.test
Branch: Jun2023
Log Message:
Extend test after update of web doc page.
diffs (71 lines):
diff --git
a/sql/test/sys-schema/Tests/webExamplesLogicalFunctionsOperators.test
b/sql/test/sys-schema/Tests/webExamplesLogicalFunctionsOperators.test
--- a/sql/test/sys-schema/Tests/webExamplesLogicalFunctionsOperators.test
+++ b/sql/test/sys-schema/Tests/webExamplesLogicalFunctionsOperators.test
@@ -129,6 +129,16 @@ 1
0
0
+query II rowsort
+select distinct a, a = NULL as "a = NULL" from b
+----
+0
+NULL
+1
+NULL
+NULL
+NULL
+
query IIIIIIII rowsort
select b.*, a and b, "and"(a,b), a or b, "or"(a,b), not a, "xor"(a,b) from b
----
@@ -205,6 +215,12 @@ NULL
NULL
NULL
+statement error
+select a, b, "all"(a, b, a) as "all(a, b, a)", "all"(a, b, b) as "all(a, b,
b)" from b
+
+statement error
+select a, b, "any"(a, b, a) as "any(a, b, a)", "any"(a, b, b) as "any(a, b,
b)" from b
+
query III rowsort
select a, b, coalesce(a, b) as "coalesce(a,b)" from b
----
@@ -236,6 +252,37 @@ NULL
NULL
NULL
+query III rowsort
+select a, b, {fn IFNULL(a, b)} as "IFNULL(a,b)" from b
+----
+0
+0
+0
+0
+1
+0
+0
+NULL
+0
+1
+0
+1
+1
+1
+1
+1
+NULL
+1
+NULL
+0
+0
+NULL
+1
+1
+NULL
+NULL
+NULL
+
statement ok
create view b3 as select a,b,true as c from b union all select a,b,false as c
from b union all select a,b,null as c from b
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
