Changeset: aaa2900442dd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/aaa2900442dd
Modified Files:
sql/test/odbc-escape-sequences/Tests/system-functions.test
Branch: Jun2023
Log Message:
Added more tests.
diffs (49 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
@@ -1,14 +1,39 @@
-query T rowsort
-select { fn user() }
-----
-monetdb
+# ref:
https://learn.microsoft.com/en-us/sql/odbc/reference/appendixes/system-functions
query I rowsort
-select length((select { fn database() })) > 0
+select { fn LENGTH( { fn DATABASE ( ) })} > 0
----
1
query I rowsort
-select { fn ifnull(NULL, 1) }
+select length(DATABASE()) > 0
+----
+1
+
+
+query I rowsort
+select { fn IFNULL(NULL, 1) }
----
1
+
+query T rowsort
+select { fn IFNULL('abc', 'def') }
+----
+abc
+
+query R rowsort
+select { fn IFNULL(NULLIF(3,3), -9.0/+4) }
+----
+-2.250
+
+statement error
+select IFNULL('abc', 'def')
+
+
+query T rowsort
+select { fn USER() }
+----
+monetdb
+
+statement error
+select USER()
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
