Changeset: 9ee200ae0a55 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9ee200ae0a55 Modified Files: sql/test/BugTracker-2026/Tests/7857-rollup-crash.test sql/test/BugTracker-2026/Tests/7864-rel_exp_visitor-crash.test Branch: pp_hashjoin Log Message:
approved tests diffs (24 lines): diff --git a/sql/test/BugTracker-2026/Tests/7857-rollup-crash.test b/sql/test/BugTracker-2026/Tests/7857-rollup-crash.test --- a/sql/test/BugTracker-2026/Tests/7857-rollup-crash.test +++ b/sql/test/BugTracker-2026/Tests/7857-rollup-crash.test @@ -2,9 +2,5 @@ statement error 22018!conversion of stri SELECT * FROM ( SELECT * FROM ( SELECT 1 AS x ) WHERE x IN ( SELECT ALL sql_min ( NULL , NULL ) FROM ( SELECT * FROM ( WITH x AS ( SELECT 1 ) SELECT ( SELECT CASE WHEN NOT NULL THEN 4 * - 48 * 51 * - - 54 * - 77 * 46 WHEN NOT ( NULL ) IN ( - ( - - 49 ) * - 1 , - 41 , - 14 % - CASE - - 1 WHEN - - 82 THEN - 22 ^ COUNT ( * ) END / 46 - - 87 * 52 ) THEN 56 ELSE NULL END FROM ( SELECT SUM ( 0 ) OVER ( ORDER BY SUM ( '$.f2' BETWEEN 1 AND 1 ) ) FROM x GROUP BY rollup ( x , x ) ORDER BY x , x , x ) , ( SELECT x AS x ) WHERE x = 'x' ) , 'x' FROM x ) WHERE ( x % 7 ) = 0 ) ) ) query I nosort -SELECT * FROM ( SELECT * FROM ( SELECT 1 AS x ) WHERE x IN ( SELECT ALL sql_min ( NULL , NULL ) FROM ( SELECT * FROM ( WITH x AS ( SELECT 1 ) SELECT ( SELECT CASE WHEN NOT NULL THEN 4 * - 48 * 51 * - - 54 * - 77 * 46 WHEN NOT ( NULL ) IN ( - ( - - 49 ) * - 1 , - 41 , - 14 % - CASE - - 1 WHEN - - 82 THEN - 22 ^ COUNT ( * ) END / 46 - - 87 * 52 ) THEN 56 ELSE NULL END FROM ( SELECT SUM ( 0 ) OVER ( ORDER BY SUM ( '$.f2' BETWEEN 1 AND 1 ) ) FROM x GROUP BY rollup ( x , x ) ORDER BY x , x , x ) , ( SELECT x AS x ) WHERE x = x ) , 'x' FROM x ) WHERE ( x % 7 ) = 0 ) ) ) ----- - -query I nosort SELECT * FROM ( SELECT * FROM ( SELECT 1 AS x ) WHERE x IN ( SELECT ALL sql_min ( NULL , NULL ) FROM ( SELECT * FROM ( WITH x AS ( SELECT 1 ) SELECT ( SELECT CASE WHEN NOT NULL THEN 4 * - 48 * 51 * - - 54 * - 77 * 46 WHEN NOT ( NULL ) IN ( - ( - - 49 ) * - 1 , - 41 , - 14 % - CASE - - 1 WHEN - - 82 THEN - 22 ^ COUNT ( * ) END / 46 - - 87 * 52 ) THEN 56 ELSE NULL END FROM ( SELECT SUM ( 0 ) OVER ( ORDER BY SUM ( 2 BETWEEN 1 AND 1 ) ) FROM x GROUP BY rollup ( x , x ) ORDER BY x , x , x ) , ( SELECT x AS x ) WHERE x = x ) , 'x' FROM x ) WHERE ( x % 7 ) = 0 ) ) ) ---- diff --git a/sql/test/BugTracker-2026/Tests/7864-rel_exp_visitor-crash.test b/sql/test/BugTracker-2026/Tests/7864-rel_exp_visitor-crash.test --- a/sql/test/BugTracker-2026/Tests/7864-rel_exp_visitor-crash.test +++ b/sql/test/BugTracker-2026/Tests/7864-rel_exp_visitor-crash.test @@ -1,6 +1,5 @@ -query I rowsort +statement error 22018!conversion of string to type bte failed. SELECT * FROM ( SELECT * FROM ( SELECT 1 AS x ) WHERE x IN ( SELECT ALL sql_min ( NULL , NULL ) FROM ( SELECT * FROM ( WITH x AS ( SELECT 1 WHERE ( 1 , 2 ) IN ( ( CAST( x AS TEXT ) , 4 ) , ( 1 , 2 ) ) ) SELECT ( SELECT x FROM ( SELECT SUM ( 0 ) OVER ( ORDER BY SUM ( 0 BETWEEN 1 AND 1 ) ) FROM x GROUP BY rollup ( x , x ) ORDER BY CAST( - 70 + - 89 - ( SUM ( CASE - NULLIF ( 87 , CASE CAST( NULL AS INTEGER ) WHEN 13 / ( 68 * - ( 64 ) ) THEN 39 WHEN 70 * - 95 THEN 60 ELSE 15 + 25 END * 5 ) WHEN 36 THEN NULL WHEN 24 THEN NULL ELSE 66 END ) ) AS BIGINT ) DESC , x , x ) , ( SELECT x AS x ) WHERE x = 'x' ) , 'x' FROM x ) WHERE ( x % 7 ) = 0 ) ) ) ----- query I rowsort _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
