Changeset: 70920c6927ca for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/70920c6927ca Modified Files: sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test sql/test/pg_regress/Tests/time.test sql/test/pg_regress/Tests/timestamp.test sql/test/pg_regress/Tests/timestamptz.test Branch: default Log Message:
tests were designed for CET ie UTC+1 diffs (41 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 @@ -1,4 +1,7 @@ # ref: https://learn.microsoft.com/en-us/sql/odbc/reference/appendixes/time-date-and-interval-functions +# +statement ok +set time zone interval '1' hour query I rowsort select { fn current_date() } > date'2023-01-02' diff --git a/sql/test/pg_regress/Tests/time.test b/sql/test/pg_regress/Tests/time.test --- a/sql/test/pg_regress/Tests/time.test +++ b/sql/test/pg_regress/Tests/time.test @@ -1,3 +1,6 @@ +statement ok +SET TIME ZONE INTERVAL '1' HOUR + statement ok CREATE TABLE TIME_TBL (f1 time(2)) diff --git a/sql/test/pg_regress/Tests/timestamp.test b/sql/test/pg_regress/Tests/timestamp.test --- a/sql/test/pg_regress/Tests/timestamp.test +++ b/sql/test/pg_regress/Tests/timestamp.test @@ -1,3 +1,6 @@ +statement ok +SET TIME ZONE INTERVAL '1' HOUR + statement ok CREATE TABLE TIMESTAMP_TBL ( d1 timestamp(2) ) diff --git a/sql/test/pg_regress/Tests/timestamptz.test b/sql/test/pg_regress/Tests/timestamptz.test --- a/sql/test/pg_regress/Tests/timestamptz.test +++ b/sql/test/pg_regress/Tests/timestamptz.test @@ -1,3 +1,6 @@ +statement ok +SET TIME ZONE INTERVAL '1' HOUR + statement ok CREATE TABLE TIMESTAMPTZ_TBL ( d1 timestamp(2) with time zone) _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
