Changeset: e1a6156612ca for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e1a6156612ca
Added Files:
sql/test/BugTracker-2026/Tests/8010-first_value-last_value-partition-range-bug.test
Modified Files:
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
Add test for issue #8010
diffs (53 lines):
diff --git
a/sql/test/BugTracker-2026/Tests/8010-first_value-last_value-partition-range-bug.test
b/sql/test/BugTracker-2026/Tests/8010-first_value-last_value-partition-range-bug.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2026/Tests/8010-first_value-last_value-partition-range-bug.test
@@ -0,0 +1,40 @@
+query TIIIII rowsort
+WITH t(p, id, v) AS (VALUES ('a', 1, 10), ('a', 2, 20), ('a', 3, 30), ('b', 4,
7), ('b', 5, 11))
+SELECT p, id,
+ FIRST_VALUE(v) OVER (PARTITION BY p RANGE BETWEEN CURRENT ROW AND CURRENT
ROW) AS actual_first,
+ LAST_VALUE(v) OVER (PARTITION BY p RANGE BETWEEN CURRENT ROW AND CURRENT
ROW) AS actual_last,
+ FIRST_VALUE(v) OVER (PARTITION BY p RANGE BETWEEN UNBOUNDED PRECEDING AND
UNBOUNDED FOLLOWING) AS full_first_control,
+ LAST_VALUE(v) OVER (PARTITION BY p RANGE BETWEEN UNBOUNDED PRECEDING AND
UNBOUNDED FOLLOWING) AS full_last_control
+FROM t ORDER BY id
+----
+a
+1
+10
+30
+10
+30
+a
+2
+10
+30
+10
+30
+a
+3
+10
+30
+10
+30
+b
+4
+7
+11
+7
+11
+b
+5
+7
+11
+7
+11
+
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
@@ -190,3 +190,4 @@ KNOWNFAIL?8006-field-function-bug
KNOWNFAIL?8007-lag-lead-window-functions-bug
KNOWNFAIL?8008-numeric-range-frame-bug
KNOWNFAIL?8009-numeric-range-nulls-last-bug
+KNOWNFAIL?8010-first_value-last_value-partition-range-bug
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
