Changeset: cb755b0efff9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cb755b0efff9 Added Files: sql/test/BugTracker-2023/Tests/All sql/test/BugTracker-2023/Tests/interval-day-and-second.Bug-7353.test Branch: interval-day-second Log Message:
Add a test for the INTERVAL SECOND - INTERVAL DAY bug diffs (22 lines): diff --git a/sql/test/BugTracker-2023/Tests/All b/sql/test/BugTracker-2023/Tests/All new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2023/Tests/All @@ -0,0 +1,1 @@ +interval-day-and-second.Bug-7353 diff --git a/sql/test/BugTracker-2023/Tests/interval-day-and-second.Bug-7353.test b/sql/test/BugTracker-2023/Tests/interval-day-and-second.Bug-7353.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2023/Tests/interval-day-and-second.Bug-7353.test @@ -0,0 +1,11 @@ +query TTI nosort +SELECT + CAST(CAST(value AS TEXT) AS INTERVAL HOUR) AS hours_col, + CAST(CAST(value AS TEXT) AS INTERVAL SECOND) AS seconds_col, + 42 AS fortytwo +FROM sys.generate_series(1, 2); +---- +1:00:00 +0:00:01 +42 + _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
