Changeset: 0cd0365812fc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0cd0365812fc Added Files: sql/test/BugTracker-2026/Tests/7956-rel_remove_const_aggr-crash.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7956 diffs (194 lines): diff --git a/sql/test/BugTracker-2026/Tests/7956-rel_remove_const_aggr-crash.test b/sql/test/BugTracker-2026/Tests/7956-rel_remove_const_aggr-crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7956-rel_remove_const_aggr-crash.test @@ -0,0 +1,181 @@ +-- query with disabled 'ORDER BY , 71 + - AVG ( 0.100000 ) + 12 / - - COUNT ( * )' part works +query IRI rowsort +SELECT a , b , c + FROM ( SELECT 1 AS a , 2 AS b , 3 AS c + UNION ALL + SELECT 4 AS a , NULL AS b , 6 AS c + UNION ALL + SELECT 7 AS a , 1.770000 AS b , 9 AS c ) AS t + GROUP BY ROLLUP ( a , b ) , ROLLUP ( a , c ) + ORDER BY a +-- , 71 + - AVG ( 0.100000 ) + 12 / - - COUNT ( * ) + , c + LIMIT 99 +---- +1 +2.000 +3 +1 +2.000 +NULL +1 +2.000 +NULL +1 +NULL +3 +1 +NULL +3 +1 +NULL +NULL +1 +NULL +NULL +1 +NULL +NULL +4 +NULL +6 +4 +NULL +6 +4 +NULL +6 +4 +NULL +NULL +4 +NULL +NULL +4 +NULL +NULL +4 +NULL +NULL +4 +NULL +NULL +7 +1.770 +9 +7 +1.770 +NULL +7 +1.770 +NULL +7 +NULL +9 +7 +NULL +9 +7 +NULL +NULL +7 +NULL +NULL +7 +NULL +NULL +NULL +NULL +NULL + +-- the orginal reported query +-- it crashes in rel_remove_const_aggr (v=0x7f551bffe6b0, rel=0x7f550c1b2f30) at sql/server/rel_optimize_proj.c:2725 +query IRI rowsort +SELECT a , b , c + FROM ( SELECT 1 AS a , 2 AS b , 3 AS c + UNION ALL + SELECT 4 AS a , NULL AS b , 6 AS c + UNION ALL + SELECT 7 AS a , 1.770000 AS b , 9 AS c ) AS t + GROUP BY ROLLUP ( a , b ) , ROLLUP ( a , c ) + ORDER BY a + , 71 + - AVG ( 0.100000 ) + 12 / - - COUNT ( * ) + , c + LIMIT 99 +---- +1 +2.000 +3 +1 +2.000 +NULL +1 +2.000 +NULL +1 +NULL +3 +1 +NULL +3 +1 +NULL +NULL +1 +NULL +NULL +1 +NULL +NULL +4 +NULL +6 +4 +NULL +6 +4 +NULL +6 +4 +NULL +NULL +4 +NULL +NULL +4 +NULL +NULL +4 +NULL +NULL +4 +NULL +NULL +7 +1.770 +9 +7 +1.770 +NULL +7 +1.770 +NULL +7 +NULL +9 +7 +NULL +9 +7 +NULL +NULL +7 +NULL +NULL +7 +NULL +NULL +NULL +NULL +NULL + 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 @@ -141,3 +141,4 @@ KNOWNFAIL?7952-rel_find_exp_and_correspo KNOWNFAIL?7953-list_append_node-crash KNOWNFAIL?7954-exp_visitor-crash KNOWNFAIL?7955-rel_setop_get_statistics-crash +KNOWNFAIL?7956-rel_remove_const_aggr-crash _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
