Changeset: 95c174a625a9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/95c174a625a9 Added Files: sql/test/BugTracker-2026/Tests/8007-lag-lead-window-functions-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #8007 diffs (62 lines): diff --git a/sql/test/BugTracker-2026/Tests/8007-lag-lead-window-functions-bug.test b/sql/test/BugTracker-2026/Tests/8007-lag-lead-window-functions-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/8007-lag-lead-window-functions-bug.test @@ -0,0 +1,49 @@ +statement ok +CREATE TABLE lag_lead_default_expr_bug(g INT, id INT, x INT, d INT) + +statement ok rowcount 4 +INSERT INTO lag_lead_default_expr_bug VALUES + (1, 1, 10, 99), + (1, 2, 20, 88), + (2, 1, 30, 77), + (2, 2, 40, 66) + +query IIIIII rowsort +SELECT + g, + id, + LAG(x, 1, d) OVER (PARTITION BY g ORDER BY id) AS lag_actual, + CASE WHEN id = 1 THEN d ELSE x - 10 END AS lag_expected, + LEAD(x, 1, d) OVER (PARTITION BY g ORDER BY id) AS lead_actual, + CASE WHEN id = 1 THEN x + 10 ELSE d END AS lead_expected +FROM lag_lead_default_expr_bug +ORDER BY g, id +---- +1 +1 +99 +99 +20 +20 +1 +2 +10 +10 +88 +88 +2 +1 +77 +77 +40 +40 +2 +2 +30 +30 +66 +66 + +statement ok +DROP TABLE lag_lead_default_expr_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 @@ -187,3 +187,4 @@ KNOWNFAIL?8003-windowed-group_concat-ign KNOWNFAIL?8004-nth_value-windowfunction-bug KNOWNFAIL?8005-prod-aggr-function-bug KNOWNFAIL?8006-field-function-bug +KNOWNFAIL?8007-lag-lead-window-functions-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
