Changeset: 22b998f6eaac for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/22b998f6eaac
Modified Files:
sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
Branch: default
Log Message:
Add some more tests.
diffs (39 lines):
diff --git
a/sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
b/sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
--- a/sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
+++ b/sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
@@ -4,6 +4,11 @@ select { fn current_date() } > date'2023
1
query I rowsort
+select { fn current_date() } > {d'2023-01-02'}
+----
+1
+
+query I rowsort
select length((select { fn current_date() })) > 0
----
1
@@ -19,6 +24,11 @@ select { fn current_time() } >= time'00:
1
query I rowsort
+select { fn current_time() } >= {t'00:00:00'}
+----
+1
+
+query I rowsort
select length(cast((select { fn current_time() }) as varchar(100))) > 0
----
1
@@ -34,6 +44,11 @@ select { fn current_timestamp() } > time
1
query I rowsort
+select { fn current_timestamp() } > {ts'2023-01-02 00:00:00'}
+----
+1
+
+query I rowsort
select length(cast((select { fn current_timestamp() }) as varchar(100))) > 0
----
1
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
