Changeset: 1172b48bcbd1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1172b48bcbd1 Added Files: sql/test/BugTracker-2026/Tests/8003-windowed-group_concat-ignores-orderby-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #8003 diffs (41 lines): diff --git a/sql/test/BugTracker-2026/Tests/8003-windowed-group_concat-ignores-orderby-bug.test b/sql/test/BugTracker-2026/Tests/8003-windowed-group_concat-ignores-orderby-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/8003-windowed-group_concat-ignores-orderby-bug.test @@ -0,0 +1,28 @@ +statement ok +CREATE TABLE t8003(id INT, s VARCHAR(10)) + +statement ok rowcount 3 +INSERT INTO t8003 VALUES (1, 'b'), (2, 'c'), (3, 'a') + +query ITT rowsort +SELECT id, + GROUP_CONCAT(s ORDER BY s) OVER ( + ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING + ) AS actual, + (SELECT GROUP_CONCAT(r.s ORDER BY r.s) FROM t8003 r) AS expected +FROM t8003 +ORDER BY id +---- +1 +a,b,c +a,b,c +2 +a,b,c +a,b,c +3 +a,b,c +a,b,c + +statement ok +DROP TABLE t8003 + 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 @@ -183,3 +183,4 @@ KNOWNFAIL?7998-scalar-subquery-error-msg KNOWNFAIL?8000-select-count-distinct-assert-failure KNOWNFAIL?8001-select-count-where-having-bug KNOWNFAIL?8002-schema-renaming-makes-seq-invalid-bug +KNOWNFAIL?8003-windowed-group_concat-ignores-orderby-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
