Changeset: f9d9685ea1d2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f9d9685ea1d2
Modified Files:
sql/test/odbc-escape-sequences/Tests/system-functions.test
Branch: default
Log Message:
Approve output after implementing IFNULL() in parser
diffs (25 lines):
diff --git a/sql/test/odbc-escape-sequences/Tests/system-functions.test
b/sql/test/odbc-escape-sequences/Tests/system-functions.test
--- a/sql/test/odbc-escape-sequences/Tests/system-functions.test
+++ b/sql/test/odbc-escape-sequences/Tests/system-functions.test
@@ -26,8 +26,20 @@ select { fn IFNULL(NULLIF(3,3), -9.0/+4)
----
-2.250
-statement error
+query I rowsort
+select IFNULL(NULL, 1)
+----
+1
+
+query T rowsort
select IFNULL('abc', 'def')
+----
+abc
+
+query R rowsort
+select IFNULL(NULLIF(3,3), -9.0/+4)
+----
+-2.250
query T rowsort
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
