Changeset: 85a7a788b4ae for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/85a7a788b4ae
Added Files:
sql/test/BugTracker-2026/Tests/7990-rank-filter-bug.test
Modified Files:
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
Add test for issue #7990
diffs (59 lines):
diff --git a/sql/test/BugTracker-2026/Tests/7990-rank-filter-bug.test
b/sql/test/BugTracker-2026/Tests/7990-rank-filter-bug.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7990-rank-filter-bug.test
@@ -0,0 +1,46 @@
+-- query without the WHERE r <= 1 works fine
+query III rowsort
+WITH t(id,x) AS (
+ VALUES (1,10), (2,10), (3,20), (4,30)
+)
+SELECT id, x, r
+FROM (
+ SELECT id, x, RANK() OVER (ORDER BY x) AS r
+ FROM t
+) AS s
+-- WHERE r <= 1
+ORDER BY id
+----
+1
+10
+1
+2
+10
+1
+3
+20
+3
+4
+30
+4
+
+-- query with the WHERE r <= 1 works incorrect (removes row {2,10,1})
+query III rowsort
+WITH t(id,x) AS (
+ VALUES (1,10), (2,10), (3,20), (4,30)
+)
+SELECT id, x, r
+FROM (
+ SELECT id, x, RANK() OVER (ORDER BY x) AS r
+ FROM t
+) AS s
+WHERE r <= 1
+ORDER BY id
+----
+1
+10
+1
+2
+10
+1
+
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
@@ -170,3 +170,4 @@ KNOWNFAIL?7985-qualify-row_number-over-b
KNOWNFAIL?7986-right-function-bug
KNOWNFAIL?7987-where-null-bug
KNOWNFAIL?7989-window-avg-bug
+KNOWNFAIL?7990-rank-filter-bug
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
