Changeset: f299cb56a4f6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f299cb56a4f6 Added Files: sql/test/BugTracker-2026/Tests/8008-numeric-range-frame-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #8008 diffs (41 lines): diff --git a/sql/test/BugTracker-2026/Tests/8008-numeric-range-frame-bug.test b/sql/test/BugTracker-2026/Tests/8008-numeric-range-frame-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/8008-numeric-range-frame-bug.test @@ -0,0 +1,28 @@ +query IIIIII rowsort +WITH t(id, p, k, v) AS ( + VALUES (1, 0, 0, 1), (2, 1, 1, 0), (3, 0, 2, 3) +) +SELECT id, p, k, v, + SUM(v) OVER (PARTITION BY p ORDER BY k ASC NULLS LAST RANGE BETWEEN 0 PRECEDING AND 1 FOLLOWING) AS actual, + (SELECT SUM(r.v) FROM t AS r WHERE (r.p = t.p OR (r.p IS NULL AND t.p IS NULL)) AND r.k BETWEEN t.k AND t.k + 1) AS expected +FROM t ORDER BY id +---- +1 +0 +0 +1 +1 +1 +2 +1 +1 +0 +0 +0 +3 +0 +2 +3 +3 +3 + 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 @@ -188,3 +188,4 @@ KNOWNFAIL?8004-nth_value-windowfunction- KNOWNFAIL?8005-prod-aggr-function-bug KNOWNFAIL?8006-field-function-bug KNOWNFAIL?8007-lag-lead-window-functions-bug +KNOWNFAIL?8008-numeric-range-frame-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
