Changeset: 9372cbdc7527 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/9372cbdc7527
Added Files:
        sql/test/BugTracker-2026/Tests/7955-rel_setop_get_statistics-crash.test
Modified Files:
        sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:

Add test for #7955


diffs (39 lines):

diff --git 
a/sql/test/BugTracker-2026/Tests/7955-rel_setop_get_statistics-crash.test 
b/sql/test/BugTracker-2026/Tests/7955-rel_setop_get_statistics-crash.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7955-rel_setop_get_statistics-crash.test
@@ -0,0 +1,26 @@
+-- adapted query without the last 'WHERE x NOT IN ( WITH RECURSIVE ...)' part 
works.
+query T nosort
+SELECT COUNT ( * ) = 0 AS x
+  FROM ( SELECT 1 AS x
+         UNION
+         SELECT 0 AS x
+         UNION
+         SELECT 3 AS x )
+----
+False
+
+-- the orginal reported query
+-- it crashes in rel_setop_get_statistics (sql=0x7feb0c184180, 
rel=0x7feb0c1b0e90, lexps=0x7feb0c1b09e0, rexps=0x7feb0c1b0fc0, 
e=0x7feb0c1b11d0, i=1) at sql/server/rel_statistics.c:300
+query T nosort
+SELECT COUNT ( * ) = 0 AS x
+  FROM ( SELECT 1 AS x
+         UNION
+         SELECT 0 AS x
+         UNION
+         SELECT 3 AS x )
+ WHERE x NOT IN ( WITH RECURSIVE x AS ( SELECT 1 UNION SELECT x + 1 FROM x 
WHERE x < 20 )
+                  SELECT * FROM x WHERE x >= 1
+                )
+----
+False
+
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
@@ -140,3 +140,4 @@ KNOWNFAIL?7951-exp_visitor-crash
 KNOWNFAIL?7952-rel_find_exp_and_corresponding_rel_-assert-failure
 KNOWNFAIL?7953-list_append_node-crash
 KNOWNFAIL?7954-exp_visitor-crash
+KNOWNFAIL?7955-rel_setop_get_statistics-crash
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to