Changeset: ef50dda6c512 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ef50dda6c512 Added Files: sql/test/BugTracker-2026/Tests/7989-window-avg-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #7989 diffs (79 lines): diff --git a/sql/test/BugTracker-2026/Tests/7989-window-avg-bug.test b/sql/test/BugTracker-2026/Tests/7989-window-avg-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7989-window-avg-bug.test @@ -0,0 +1,66 @@ +query IRR rowsort +WITH t AS ( + SELECT value AS id, CAST(value - 1 AS DOUBLE) AS v + FROM generate_series(1, 18) +) +SELECT id, + AVG(v) OVER ( + ORDER BY id + ROWS BETWEEN 16 PRECEDING AND CURRENT ROW + ) AS actual, + (SELECT AVG(r.v) FROM t AS r WHERE r.id <= t.id) AS expected +FROM t +ORDER BY id +---- +1 +0.000 +0.000 +10 +4.500 +4.500 +11 +5.000 +5.000 +12 +5.500 +5.500 +13 +6.000 +6.000 +14 +6.500 +6.500 +15 +7.000 +7.000 +16 +7.500 +7.500 +17 +8.000 +8.000 +2 +0.500 +0.500 +3 +1.000 +1.000 +4 +1.500 +1.500 +5 +2.000 +2.000 +6 +2.500 +2.500 +7 +3.000 +3.000 +8 +3.500 +3.500 +9 +4.000 +4.000 + 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 @@ -169,3 +169,4 @@ KNOWNFAIL?7984-exists-select-count-bug KNOWNFAIL?7985-qualify-row_number-over-bug KNOWNFAIL?7986-right-function-bug KNOWNFAIL?7987-where-null-bug +KNOWNFAIL?7989-window-avg-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
