Changeset: 4273ed4256c5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4273ed4256c5 Added Files: sql/test/BugTracker-2026/Tests/7960-isLikeOp-crash.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7960 diffs (31 lines): diff --git a/sql/test/BugTracker-2026/Tests/7960-isLikeOp-crash.test b/sql/test/BugTracker-2026/Tests/7960-isLikeOp-crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7960-isLikeOp-crash.test @@ -0,0 +1,18 @@ +statement error 42S02!SELECT: no such table 't1' +SELECT log , COUNT ( * ) FROM t1 GROUP BY log + UNION +SELECT log , n FROM t1 WHERE n = 7 ORDER BY COUNT ( * ) , log + +statement error 42000!syntax error, unexpected STRING in: "select null union all select null union all select 1 union all select 2 as 'x'" +SELECT NULL UNION ALL SELECT NULL UNION ALL SELECT 1 UNION ALL SELECT 2 AS 'x' ORDER BY x + +statement error 22018!conversion of string to type bte failed. +WITH RECURSIVE x ( x ) AS ( SELECT 1 UNION ALL SELECT x + 1 FROM x WHERE x < 8 ) SELECT x FROM x WHERE x = '<your_schema_name>' AND x = '<your_table_name>' AND x = 'YES' + +# next query crashes in isLikeOp (p=0x0) at monetdb5/optimizer/opt_support.c:462 because p = 0x0 +# It is called from OPTpushselectImplementation (ctx=0x3a647510, mb=0x7f6a6c2147f0, stk=0x0, pci=0x7f6a6c14bfd0) at monetdb5/optimizer/opt_pushselect.c:308 +statement error 22018!conversion of string to type bte failed. +SELECT x LIKE '%51%' FROM ( +WITH RECURSIVE x ( x ) AS ( SELECT 1 UNION ALL SELECT x + 1 FROM x WHERE x < 8 ) SELECT x FROM x WHERE x = '<your_schema_name>' AND x = '<your_table_name>' AND x = 'YES' +) AS temp + 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 @@ -144,3 +144,4 @@ KNOWNFAIL?7955-rel_setop_get_statistics- KNOWNFAIL?7956-rel_remove_const_aggr-crash KNOWNFAIL?7957-tail_type-crash 7959-double-function-destroy +KNOWNFAIL?7960-isLikeOp-crash _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
