Changeset: 722dc858a546 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/722dc858a546
Modified Files:
sql/test/sys-schema/Tests/webExamplesComparisonFunctionsOperators.test
Branch: default
Log Message:
Approve output after implementing IFNULL() in parser
diffs (104 lines):
diff --git
a/sql/test/sys-schema/Tests/webExamplesComparisonFunctionsOperators.test
b/sql/test/sys-schema/Tests/webExamplesComparisonFunctionsOperators.test
--- a/sql/test/sys-schema/Tests/webExamplesComparisonFunctionsOperators.test
+++ b/sql/test/sys-schema/Tests/webExamplesComparisonFunctionsOperators.test
@@ -115,20 +115,30 @@ select coalesce('aa', 'b') as aa
----
aa
-statement error
+query T rowsort
select ifnull('aa', 'b') as aa
+----
+aa
-statement error
+query T rowsort
select ifnull(null, 'ams') as ams
+----
+ams
-statement error
+query T rowsort
select ifnull(null, null) as nul
+----
+NULL
-statement error
+query T rowsort
select ifnull('aa', null) as aa
+----
+aa
-statement error
+query I rowsort
select ifnull(true, null) as tru
+----
+1
query T rowsort
select {fn IFNULL('aa', 'b')} as aa
@@ -164,14 +174,61 @@ create table t6933 (i int, c varchar(8))
statement ok
insert into t6933 values (1, 'aa1'), (2, null), (null, 'bb2'), (null, null)
-statement error
+query ITITT rowsort
select i, c, ifnull(i, 2*3) as "ifnull(i,2*3)", ifnull(c, 'has null') as
"ifnull(i,'x')", ifnull(i, c) as "ifnull(i,c)" from t6933
+----
+1
+aa1
+1
+aa1
+1
+2
+NULL
+2
+has null
+2
+NULL
+NULL
+6
+has null
+NULL
+NULL
+bb2
+6
+bb2
+bb2
-statement error
+query TIT rowsort
select c, i, ifnull(c, i) as "ifnull(c,i)" from t6933
+----
+NULL
+2
+2
+NULL
+NULL
+NULL
+aa1
+1
+aa1
+bb2
+NULL
+bb2
-statement error
+query TIT rowsort
select c, i, ifnull(c, cast(i as char)) as "ifnull(c,i)" from t6933
+----
+NULL
+2
+2
+NULL
+NULL
+NULL
+aa1
+1
+aa1
+bb2
+NULL
+bb2
query ITITT rowsort
select i, c, {fn ifnull(i, 2*3)} as "ifnull(i,2*3)", { fn ifnull(c, 'has
null') } as "ifnull(i,'x')", { fn ifnull(i, c)} as "ifnull(i,c)" from t6933
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
