Changeset: 141109dd6690 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/141109dd6690 Added Files: sql/test/BugTracker-2026/Tests/7953-list_append_node-crash.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7953 diffs (61 lines): diff --git a/sql/test/BugTracker-2026/Tests/7953-list_append_node-crash.test b/sql/test/BugTracker-2026/Tests/7953-list_append_node-crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7953-list_append_node-crash.test @@ -0,0 +1,48 @@ +-- with the 'WHERE ( SELECT group_concat ( '' ) ....' part disabled it generates an error +statement error 22018!conversion of string to type dbl failed. +SELECT MIN ( x ) + FROM ( WITH RECURSIVE x ( x ) AS + ( WITH RECURSIVE x ( x ) AS ( + SELECT REPEAT ( 'MonetDb' , 1000 ) + UNION + SELECT 33 * - 49 * CASE 50 WHEN - 21 + 0 + - COUNT ( * ) THEN NULL WHEN 99 * - 43 + - - 35 THEN - 75 ELSE NULL END * - - 51 * 0 + FROM x + WHERE x < 20 ) + SELECT 1 + UNION + SELECT x + 1 + FROM x +-- WHERE ( SELECT group_concat ( '' ) OVER ( ORDER BY 1 , 1 GROUPS BETWEEN 5 PRECEDING AND 0 FOLLOWING ) +-- WHERE levenshtein ( '\xf4\x8f\xbf\xbf' , 2 , 1 , 1 ) NOT IN ( SELECT right_shift ( 8 , 2 ) GROUP BY x HAVING avg ( DISTINCT x ) < 3 EXCEPT SELECT 2 AS x UNION SELECT 3 AS x GROUP BY CUBE ( x , x , x ) HAVING NOT - - ( EXISTS ( SELECT 1 ) ) = ANY ( NOT MAX ( x ) < AVG ( x ) ) ) +-- ORDER BY x IS NULL +-- ) < ( x IN ( SELECT 'a.b.c.d.e' LIKE 'a.%' FROM x ) ) + ) + SELECT x * ( 10 - x ) AS x + FROM x + ) AS x + + +-- original query crashes in list_append_node (l=0x7fc5b41e5800, n=0x7fc5b4170f80) at /home/dinther/dev/dev/MonetDB/sql/common/sql_list.c:154 +query T nosort +SELECT MIN ( x ) + FROM ( WITH RECURSIVE x ( x ) AS + ( WITH RECURSIVE x ( x ) AS ( + SELECT REPEAT ( 'MonetDb' , 1000 ) + UNION + SELECT 33 * - 49 * CASE 50 WHEN - 21 + 0 + - COUNT ( * ) THEN NULL WHEN 99 * - 43 + - - 35 THEN - 75 ELSE NULL END * - - 51 * 0 + FROM x + WHERE x < 20 ) + SELECT 1 + UNION + SELECT x + 1 + FROM x + WHERE ( SELECT group_concat ( '' ) OVER ( ORDER BY 1 , 1 GROUPS BETWEEN 5 PRECEDING AND 0 FOLLOWING ) + WHERE levenshtein ( '\xf4\x8f\xbf\xbf' , 2 , 1 , 1 ) NOT IN ( SELECT right_shift ( 8 , 2 ) GROUP BY x HAVING avg ( DISTINCT x ) < 3 EXCEPT SELECT 2 AS x UNION SELECT 3 AS x GROUP BY CUBE ( x , x , x ) HAVING NOT - - ( EXISTS ( SELECT 1 ) ) = ANY ( NOT MAX ( x ) < AVG ( x ) ) ) + ORDER BY x IS NULL + ) < ( x IN ( SELECT 'a.b.c.d.e' LIKE 'a.%' FROM x ) ) + ) + SELECT x * ( 10 - x ) AS x + FROM x + ) AS 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 @@ -138,3 +138,4 @@ KNOWNFAIL?7949-exp_match-crash KNOWNFAIL?7950-exp_set_type-crash KNOWNFAIL?7951-exp_visitor-crash KNOWNFAIL?7952-rel_find_exp_and_corresponding_rel_-assert-failure +KNOWNFAIL?7953-list_append_node-crash _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
