Changeset: 272fcc3a0514 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/272fcc3a0514 Added Files: sql/test/BugTracker-2026/Tests/7982-range-current-row-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #7982 diffs (45 lines): diff --git a/sql/test/BugTracker-2026/Tests/7982-range-current-row-bug.test b/sql/test/BugTracker-2026/Tests/7982-range-current-row-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7982-range-current-row-bug.test @@ -0,0 +1,32 @@ +statement ok +CREATE TABLE t7982(id INT, k INT, v INT) + +statement ok +INSERT INTO t7982 VALUES (1, 1, 10), (2, 2, 20), (3, 2, 30) + +query IIII rowsort +SELECT id, k, + COUNT(v) OVER ( + ORDER BY k + RANGE BETWEEN CURRENT ROW AND CURRENT ROW + ) AS actual, + (SELECT COUNT(r.v) FROM t7982 r WHERE r.k = t7982.k) AS expected +FROM t7982 +ORDER BY id +---- +1 +1 +1 +1 +2 +2 +2 +2 +3 +2 +2 +2 + +statement ok +DROP TABLE IF EXISTS t7982 + 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 @@ -163,3 +163,4 @@ KNOWNFAIL?7974-muli-column-not-in-subque 7979-prepare-error-exec-113 KNOWNFAIL?7980-lag-offset-ignored-bug 7981-not-x-lt-x-bug +KNOWNFAIL?7982-range-current-row-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
