Changeset: d26a5455cb87 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d26a5455cb87 Added Files: sql/test/BugTracker-2026/Tests/7843-assertion-failure.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7843 diffs (84 lines): diff --git a/sql/test/BugTracker-2026/Tests/7843-assertion-failure.test b/sql/test/BugTracker-2026/Tests/7843-assertion-failure.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7843-assertion-failure.test @@ -0,0 +1,71 @@ +query II rowsort +SELECT x , CASE WHEN x < 12 THEN 1 ELSE 0 END AS x FROM ( SELECT 10 AS x UNION SELECT 11 AS x UNION SELECT 12 AS x UNION SELECT 13 AS x ) +---- +10 +1 +11 +1 +12 +0 +13 +0 + +query II rowsort +SELECT x , CASE WHEN x <= 12 THEN 1 ELSE 0 END AS x FROM ( SELECT 10 AS x UNION SELECT 11 AS x UNION SELECT 12 AS x UNION SELECT 13 AS x ) +---- +10 +1 +11 +1 +12 +1 +13 +0 + +query II rowsort +SELECT x , CASE WHEN x = 12 THEN 1 ELSE 0 END AS x FROM ( SELECT 10 AS x UNION SELECT 11 AS x UNION SELECT 12 AS x UNION SELECT 13 AS x ) +---- +10 +0 +11 +0 +12 +1 +13 +0 + +query II rowsort +SELECT x , CASE WHEN x >= 12 THEN 1 ELSE 0 END AS x FROM ( SELECT 10 AS x UNION SELECT 11 AS x UNION SELECT 12 AS x UNION SELECT 13 AS x ) +---- +10 +0 +11 +0 +12 +1 +13 +1 + +query I rowsort +SELECT 10 AS x UNION SELECT 11 AS x GROUP BY CUBE ( x , x ) UNION SELECT 12 AS x UNION SELECT 13 AS x +---- +10 +11 +12 +13 +NULL + +-- next query produces assertion failure in rel_find_exp_and_corresponding_rel_ (rel=0x7f3bf81b0e80, e=0x7f3bf81adf90, subexp=false, res=0x0) at sql/server/rel_exp.c:1786 +query II rowsort +SELECT x , CASE WHEN x > 12 THEN 1 ELSE ( x = 1 AND x = ( SELECT x ORDER BY x , x DESC NULLS FIRST , x , x ) ) END AS x FROM ( SELECT 10 AS x UNION SELECT 11 AS x GROUP BY CUBE ( x , x ) UNION SELECT 12 AS x UNION SELECT 13 AS x ) +---- +10 +0 +11 +0 +12 +0 +13 +1 +NULL +0 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 @@ -45,3 +45,4 @@ KNOWNFAIL?7833-assertion-failure 7840-crash 7841-BATsubcross-more-than-one-match 7842-crash +KNOWNFAIL?7843-assertion-failure _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
