Changeset: 0d74abe0bb0e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0d74abe0bb0e Added Files: sql/test/BugTracker-2026/Tests/7961-list_empty-crash.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7961 diffs (57 lines): diff --git a/sql/test/BugTracker-2026/Tests/7961-list_empty-crash.test b/sql/test/BugTracker-2026/Tests/7961-list_empty-crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7961-list_empty-crash.test @@ -0,0 +1,44 @@ +statement error 42000!SELECT: subquery must return only one column +SELECT ( 1 , 2 , 3 ) = ( 1 , 2 , 3 ) + +statement error 42000!SELECT: subquery must return only one column +SELECT ( 1 , 2 , 3 ) < ( 1 , 2 , 3 ) + +statement error 42000!SELECT: subquery must return only one column +SELECT NOT ( ( 1 , 2 , 3 ) = ( 1 , 2 , 3 ) ) + +statement error 42000!Cannot match a tuple to a single value +SELECT ( 1 , 2 , 3 ) IN ( ( 1 ) , ( 2 ) , ( 3 ) ) + +statement error 42000!Subquery has too few columns +SELECT ( 1 , 2 , 3 ) IN ( SELECT 1 UNION SELECT 2 UNION SELECT 3 ) + +statement error 42000!SELECT: subquery must return only one column +SELECT NOT ( ( 1 , 2 , 3 ) = ( 1 , 2 , 3 ) ) + +statement error 42000!SELECT: subquery must return only one column +SELECT ( SELECT 1 AS x , 2 AS x , 3 AS x ) = ( SELECT 1 AS x , 2 AS x , 3 AS x ) + +statement error 42000!SELECT: subquery must return only one column +SELECT ( 1 , 0 , 3 ) = ( 1 , 2 , 3 ) + +statement error 42000!SELECT: subquery must return only one column +SELECT ( 1 , 0 , 3 ) != ( 1 , 2 , 3 ) + +statement error 42000!SELECT: identifier 'x' unknown +SELECT coalesce ( NULL , 2 , 'b' , COUNT ( - 14 - - CASE - - 1 WHEN - - 82 THEN - - 23 END / 46 - - not_like ( 'ab#c' , '_b_' , '#' , FALSE ) ^ 52 ) = 0 ) GROUP BY cube ( x , x , x ) UNION SELECT 2 AS x UNION SELECT 3 AS x + +query T nosort +SELECT COUNT ( * ) = 0 AS x + FROM ( SELECT 1 AS x UNION SELECT 0 AS x UNION SELECT 3 AS x ) +---- +False + +query T nosort +SELECT COUNT ( * ) = 0 AS x + FROM ( SELECT 1 AS x UNION SELECT 0 AS x UNION SELECT 3 AS x ) + WHERE x NOT IN ( SELECT coalesce ( NULL , 2 , 'b' , COUNT ( - 14 - - CASE - - 1 WHEN - - 82 THEN - - 23 END / 46 - - not_like ( 'ab#c' , '_b_' , '#' , FALSE ) ^ 52 ) = 0 ) + GROUP BY cube ( x , x , x ) UNION SELECT 2 AS x UNION SELECT 3 AS x ) +---- +False + 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 @@ -145,3 +145,4 @@ KNOWNFAIL?7956-rel_remove_const_aggr-cra KNOWNFAIL?7957-tail_type-crash 7959-double-function-destroy KNOWNFAIL?7960-isLikeOp-crash +KNOWNFAIL?7961-list_empty-crash _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
