Changeset: d3157aea0268 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d3157aea0268
Modified Files:
sql/server/sql_parser.y
sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
Branch: escape-sequences
Log Message:
small fix
diffs (28 lines):
diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y
--- a/sql/server/sql_parser.y
+++ b/sql/server/sql_parser.y
@@ -6609,7 +6609,7 @@ odbc_data_type:
| SQL_TIME
{ sql_find_subtype(&$$, "time", 0, 0); }
| SQL_TIMESTAMP
- { sql_find_subtype(&$$, "timestamp", 0, 0); }
+ { sql_find_subtype(&$$, "timestamp", 6, 0); }
| SQL_TINYINT
{ sql_find_subtype(&$$, "tinyint", 0, 0); }
| SQL_VARBINARY
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
@@ -107,6 +107,12 @@ select { fn timestampadd(SQL_TSI_HOUR, 1
----
2022-11-14 13:12:12
+# corner case
+query T rowsort
+select { fn timestampadd(SQL_TSI_DAY, 1, time'12:12:12') }
+----
+2022-11-14 13:12:12
+
query T rowsort
select { fn timestampdiff(SQL_TSI_HOUR, 1, timestamp'2022-11-14 12:12:12') }
----
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
