Changeset: 386bf651ae4a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/386bf651ae4a
Modified Files:
sql/test/BugTracker-2026/Tests/7785-recursive-cte-loops-infinitly.test
Branch: Dec2025
Log Message:
Extend test with variant which uses UNION instead of UNION ALL. It also loops.
diffs (25 lines):
diff --git
a/sql/test/BugTracker-2026/Tests/7785-recursive-cte-loops-infinitly.test
b/sql/test/BugTracker-2026/Tests/7785-recursive-cte-loops-infinitly.test
--- a/sql/test/BugTracker-2026/Tests/7785-recursive-cte-loops-infinitly.test
+++ b/sql/test/BugTracker-2026/Tests/7785-recursive-cte-loops-infinitly.test
@@ -14,6 +14,21 @@ INSERT INTO t VALUES ('a', 1, 1.1)
statement ok
INSERT INTO t VALUES ('b', 1, 2.2)
+-- next query with UNION does NOT stop
+query TI nosort
+WITH RECURSIVE cte(label, step) AS (
+ SELECT DISTINCT label, step
+ FROM t
+ UNION
+ SELECT label, step + 1
+ FROM cte
+ WHERE step < 3
+)
+SELECT COUNT(*) < 9 FROM cte
+----
+1
+
+-- next query with UNION ALL does NOT stop
query TI nosort
WITH RECURSIVE cte(label, step) AS (
SELECT DISTINCT label, step
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
