Changeset: 688469da9755 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/688469da9755 Added Files: sql/test/BugTracker-2026/Tests/7985-qualify-row_number-over-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #7985 diffs (49 lines): diff --git a/sql/test/BugTracker-2026/Tests/7985-qualify-row_number-over-bug.test b/sql/test/BugTracker-2026/Tests/7985-qualify-row_number-over-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7985-qualify-row_number-over-bug.test @@ -0,0 +1,36 @@ +statement ok +CREATE TABLE t_mdb_val_006(id INT, x INT) + +statement ok +INSERT INTO t_mdb_val_006 VALUES (1, 30), (2, 10), (3, 20) + +-- expected 2 output columns. received 3 output columns ! +-- expected id values 2 and 3. received id values 1 and 2 ! +query TI rowsort +SELECT 'actual' AS src, id +FROM t_mdb_val_006 +QUALIFY ROW_NUMBER() OVER (ORDER BY x) <= 2 +ORDER BY id +---- +actual +2 +actual +3 + +query TI rowsort +SELECT 'expected' AS src, id +FROM ( + SELECT id, ROW_NUMBER() OVER (ORDER BY x) AS rn + FROM t_mdb_val_006 +) s +WHERE rn <= 2 +ORDER BY id +---- +expected +2 +expected +3 + +statement ok +DROP TABLE IF EXISTS t_mdb_val_006 + 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 @@ -165,3 +165,4 @@ KNOWNFAIL?7980-lag-offset-ignored-bug 7981-not-x-lt-x-bug KNOWNFAIL?7982-range-current-row-bug KNOWNFAIL?7984-exists-select-count-bug +KNOWNFAIL?7985-qualify-row_number-over-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
