Changeset: 195a053bebb6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/195a053bebb6 Added Files: sql/test/BugTracker-2026/Tests/7949-exp_match-crash.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7949 diffs (32 lines): diff --git a/sql/test/BugTracker-2026/Tests/7949-exp_match-crash.test b/sql/test/BugTracker-2026/Tests/7949-exp_match-crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7949-exp_match-crash.test @@ -0,0 +1,19 @@ +-- the query without the 'GROUP BY CUBE ( x , x , x )' part doesn't crash +query I rowsort +SELECT * FROM ( + SELECT * FROM ( + SELECT 1 AS x ) + WHERE x IN ( SELECT DISTINCT - 82 * 26 - 12 * - 27 * CASE WHEN NOT NULL IN ( - 69 , 1 * CASE x * ( CAST( 1 AS REAL ) ) + 1 + 1 + 1 + 1 + 1 + 1 + 1.000000 - ( SELECT CAST( 1 AS CHAR ( 1 ) ) AS x WHERE x LIKE 1.000000 ) + 1 + 1 * x * ( SELECT 1 ) + x + 1 + 1 + 1.000000 + 1 + 1 + 1 WHEN x THEN 1 WHEN 'x' THEN 'x' END + 37 , 44 , - - 0 * 23 , - 3421 * MAX ( - 94 * 0 ) , 3 , 12 ) THEN 41 WHEN NOT - 21 / - 95 IS NOT NULL THEN 63 END AS x ) + ) +---- + +-- the orginal reported query +-- it crashes in exp_match (e1=0x7f840000001c, e2=0x7f84981bef20) at sql/server/rel_exp.c:1259 +query I rowsort +SELECT * FROM ( + SELECT * FROM ( + SELECT 1 AS x ) + WHERE x IN ( SELECT DISTINCT - 82 * 26 - 12 * - 27 * CASE WHEN NOT NULL IN ( - 69 , 1 * CASE x * ( CAST( 1 AS REAL ) ) + 1 + 1 + 1 + 1 + 1 + 1 + 1.000000 - ( SELECT CAST( 1 AS CHAR ( 1 ) ) AS x WHERE x LIKE 1.000000 ) + 1 + 1 * x * ( SELECT 1 ) + x + 1 + 1 + 1.000000 + 1 + 1 + 1 WHEN x THEN 1 WHEN 'x' THEN 'x' END + 37 , 44 , - - 0 * 23 , - 3421 * MAX ( - 94 * 0 ) , 3 , 12 ) THEN 41 WHEN NOT - 21 / - 95 IS NOT NULL THEN 63 END AS x GROUP BY CUBE ( x , x , x ) ) + ) +---- + 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 @@ -134,3 +134,4 @@ KNOWNFAIL?7945-GDKanalyticalnthvalue-cra KNOWNFAIL?7946-GDKanalyticalnthvalue-crash KNOWNFAIL?7947-exp_bin-crash KNOWNFAIL?7948-exp_bin-first_value-crash +KNOWNFAIL?7949-exp_match-crash _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
