Changeset: 1f2048efff93 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1f2048efff93
Added Files:
sql/test/BugTracker-2026/Tests/7991-group_concat-null-separator-bug.test
Modified Files:
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
Add test for issue #7991
Previous added test was incorrect.
diffs (41 lines):
diff --git
a/sql/test/BugTracker-2026/Tests/7991-group_concat-null-separator-bug.test
b/sql/test/BugTracker-2026/Tests/7991-group_concat-null-separator-bug.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7991-group_concat-null-separator-bug.test
@@ -0,0 +1,27 @@
+query TTTTTT rowsort
+WITH t(s) AS (
+ VALUES ('a'), ('b')
+)
+SELECT GROUP_CONCAT(s, CAST(NULL AS VARCHAR(1))) OVER () =
+ (SELECT GROUP_CONCAT(r.s, CAST(NULL AS VARCHAR(1))) FROM t AS r)
+ AS actual_equal,
+ TRUE AS expected_equal
+ ,GROUP_CONCAT(s, CAST(NULL AS VARCHAR(1))) OVER () as gcn1
+ ,(SELECT GROUP_CONCAT(r.s, CAST(NULL AS VARCHAR(1))) FROM t AS r) as
gcn2
+ ,GROUP_CONCAT(s, '') OVER () as gce1
+ ,(SELECT GROUP_CONCAT(r.s,'') FROM t AS r) as gce2
+FROM t
+----
+True
+True
+ab
+ab
+ab
+ab
+True
+True
+ab
+ab
+ab
+ab
+
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
@@ -171,4 +171,5 @@ KNOWNFAIL?7986-right-function-bug
KNOWNFAIL?7987-where-null-bug
KNOWNFAIL?7989-window-avg-bug
KNOWNFAIL?7990-rank-filter-bug
+7991-group_concat-null-separator-bug
KNOWNFAIL?7992-window-date-range-interval-bug
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
