Changeset: 4b12ea63eea5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4b12ea63eea5 Added Files: sql/test/BugTracker-2026/Tests/8009-numeric-range-nulls-last-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #8009 diffs (38 lines): diff --git a/sql/test/BugTracker-2026/Tests/8009-numeric-range-nulls-last-bug.test b/sql/test/BugTracker-2026/Tests/8009-numeric-range-nulls-last-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/8009-numeric-range-nulls-last-bug.test @@ -0,0 +1,25 @@ +query IIII rowsort +WITH t(id, k, v) AS (VALUES (1, NULL, 10), (2, 1, 20), (3, 2, 30), (4, 3, 40)) +SELECT id, k, + SUM(v) OVER (ORDER BY k ASC NULLS LAST RANGE BETWEEN 1 PRECEDING AND CURRENT ROW) AS actual, + CASE WHEN k IS NULL THEN (SELECT SUM(r.v) FROM t AS r WHERE r.k IS NULL) + ELSE (SELECT SUM(r.v) FROM t AS r WHERE r.k BETWEEN t.k - 1 AND t.k) END AS expected +FROM t ORDER BY id +---- +1 +NULL +10 +10 +2 +1 +20 +20 +3 +2 +50 +50 +4 +3 +70 +70 + 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 @@ -189,3 +189,4 @@ KNOWNFAIL?8005-prod-aggr-function-bug KNOWNFAIL?8006-field-function-bug KNOWNFAIL?8007-lag-lead-window-functions-bug KNOWNFAIL?8008-numeric-range-frame-bug +KNOWNFAIL?8009-numeric-range-nulls-last-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
