Changeset: c41140cc2f40 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c41140cc2f40 Added Files: sql/test/BugTracker-2026/Tests/7980-lag-offset-ignored-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #7980 diffs (29 lines): diff --git a/sql/test/BugTracker-2026/Tests/7980-lag-offset-ignored-bug.test b/sql/test/BugTracker-2026/Tests/7980-lag-offset-ignored-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7980-lag-offset-ignored-bug.test @@ -0,0 +1,16 @@ +query I rowsort +SELECT LAG(v, off) OVER (ORDER BY v) AS actual +FROM (VALUES (0, 10), (1, 20)) AS t(off, v) +---- +10 +10 + +query I rowsort +SELECT LAG(v, off) OVER (ORDER BY v) AS actual +FROM (VALUES (0, 10), (1, 20), (2, 30), (1, 40)) AS t(off, v) +---- +10 +10 +10 +30 + 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 @@ -161,3 +161,4 @@ KNOWNFAIL?7974-muli-column-not-in-subque 7977-prepare-optimize 7978-name-leak-prepare-error-recompile 7979-prepare-error-exec-113 +KNOWNFAIL?7980-lag-offset-ignored-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
