Changeset: 5de3a3eb139e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5de3a3eb139e
Added Files:
sql/test/BugTracker-2026/Tests/7785-recursive-cte-loops-infinitly.test
Modified Files:
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
Add test for #7785
diffs (48 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
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7785-recursive-cte-loops-infinitly.test
@@ -0,0 +1,32 @@
+statement ok
+CREATE TABLE t (
+ label VARCHAR(10),
+ step INTEGER,
+ value DOUBLE NOT NULL DEFAULT 0.0
+)
+
+statement ok
+INSERT INTO t VALUES ('a', 1, 1.1)
+
+statement ok
+INSERT INTO t VALUES ('a', 1, 1.1)
+
+statement ok
+INSERT INTO t VALUES ('b', 1, 2.2)
+
+query TI nosort
+WITH RECURSIVE cte(label, step) AS (
+ SELECT DISTINCT label, step
+ FROM t
+ UNION ALL
+ SELECT label, step + 1
+ FROM cte
+ WHERE step < 3
+)
+SELECT COUNT(*) < 9 FROM cte
+----
+1
+
+statement ok
+DROP TABLE t
+
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
@@ -10,6 +10,7 @@ KNOWNFAIL?7781-truncate-sys-tables-corru
7780-unnest-slow
7782-roles-view
7783-deleted-row
+KNOWNFAIL?7785-recursive-cte-loops-infinitly
7786-rename-drop-table
7804-querylog-catalog-orderby-bug
7805-orderby-all-bug
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
