Changeset: a385a8589e80 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a385a8589e80 Added Files: sql/test/BugTracker-2026/Tests/7992-window-date-range-interval-bug.test Removed Files: sql/test/BugTracker-2026/Tests/7991-window-date-range-interval-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #7992 diffs (93 lines): diff --git a/sql/test/BugTracker-2026/Tests/7991-window-date-range-interval-bug.test b/sql/test/BugTracker-2026/Tests/7991-window-date-range-interval-bug.test deleted file mode 100644 --- a/sql/test/BugTracker-2026/Tests/7991-window-date-range-interval-bug.test +++ /dev/null @@ -1,37 +0,0 @@ -query III rowsort -WITH t(id, k, v) AS ( - VALUES - (1, DATE '2024-01-01', 10), - (2, DATE '2024-01-02', 20), - (3, CAST(NULL AS DATE), 30), - (4, DATE '2024-01-03', 40), - (5, CAST(NULL AS DATE), 50) -) -SELECT id, - SUM(v) OVER ( - ORDER BY k ASC NULLS LAST - RANGE BETWEEN INTERVAL '1' DAY PRECEDING AND CURRENT ROW - ) AS actual_nulls_last, - SUM(v) OVER ( - ORDER BY k ASC NULLS FIRST - RANGE BETWEEN INTERVAL '1' DAY PRECEDING AND CURRENT ROW - ) AS actual_nulls_first -FROM t -ORDER BY id ----- -1 -10 -10 -2 -30 -30 -3 -80 -80 -4 -60 -60 -5 -80 -80 - diff --git a/sql/test/BugTracker-2026/Tests/7992-window-date-range-interval-bug.test b/sql/test/BugTracker-2026/Tests/7992-window-date-range-interval-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7992-window-date-range-interval-bug.test @@ -0,0 +1,37 @@ +query III rowsort +WITH t(id, k, v) AS ( + VALUES + (1, DATE '2024-01-01', 10), + (2, DATE '2024-01-02', 20), + (3, CAST(NULL AS DATE), 30), + (4, DATE '2024-01-03', 40), + (5, CAST(NULL AS DATE), 50) +) +SELECT id, + SUM(v) OVER ( + ORDER BY k ASC NULLS LAST + RANGE BETWEEN INTERVAL '1' DAY PRECEDING AND CURRENT ROW + ) AS actual_nulls_last, + SUM(v) OVER ( + ORDER BY k ASC NULLS FIRST + RANGE BETWEEN INTERVAL '1' DAY PRECEDING AND CURRENT ROW + ) AS actual_nulls_first +FROM t +ORDER BY id +---- +1 +10 +10 +2 +30 +30 +3 +80 +80 +4 +60 +60 +5 +80 +80 + diff --git a/sql/test/BugTracker-2026/Tests/All b/sql/test/BugTracker-2026/Tests/All --- a/sql/test/BugTracker-2026/Tests/All +++ b/sql/test/BugTracker-2026/Tests/All @@ -171,4 +171,4 @@ KNOWNFAIL?7986-right-function-bug KNOWNFAIL?7987-where-null-bug KNOWNFAIL?7989-window-avg-bug KNOWNFAIL?7990-rank-filter-bug -KNOWNFAIL?7991-window-date-range-interval-bug +KNOWNFAIL?7992-window-date-range-interval-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
