Changeset: 509244cf4f52 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/509244cf4f52 Added Files: sql/test/BugTracker-2026/Tests/8004-nth_value-windowfunction-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #8004 diffs (55 lines): diff --git a/sql/test/BugTracker-2026/Tests/8004-nth_value-windowfunction-bug.test b/sql/test/BugTracker-2026/Tests/8004-nth_value-windowfunction-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/8004-nth_value-windowfunction-bug.test @@ -0,0 +1,42 @@ +statement ok +CREATE TABLE nth_value_dynamic_n_bug(id INT, x INT, n INT) + +statement ok rowcount 1 +INSERT INTO nth_value_dynamic_n_bug VALUES (5, 42, 2) + +query ITIIT nosort +WITH actual AS ( + SELECT + NTH_VALUE(x, n) OVER ( + ORDER BY id + ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING + ) AS dynamic_n, + NTH_VALUE(x, 2) OVER ( + ORDER BY id + ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING + ) AS fixed_n, + ( + SELECT r.x + FROM nth_value_dynamic_n_bug AS r + ORDER BY r.id + LIMIT 1 OFFSET 1 + ) AS reference_n + FROM nth_value_dynamic_n_bug +) +SELECT + dynamic_n AS actual_dynamic_n, + dynamic_n IS NULL AS actual_is_null, + fixed_n AS fixed_n_control, + reference_n AS non_window_reference, + TRUE AS expected_is_null +FROM actual +---- +NULL +True +NULL +NULL +True + +statement ok +DROP TABLE nth_value_dynamic_n_bug + 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 @@ -184,3 +184,4 @@ KNOWNFAIL?8000-select-count-distinct-ass KNOWNFAIL?8001-select-count-where-having-bug KNOWNFAIL?8002-schema-renaming-makes-seq-invalid-bug KNOWNFAIL?8003-windowed-group_concat-ignores-orderby-bug +KNOWNFAIL?8004-nth_value-windowfunction-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
