Changeset: 529b6dec1f3f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/529b6dec1f3f Modified Files: sql/test/BugTracker-2026/Tests/7802-select-with-subqueries.test Branch: Dec2025 Log Message:
Different error message if no hugeint available. diffs (12 lines): diff --git a/sql/test/BugTracker-2026/Tests/7802-select-with-subqueries.test b/sql/test/BugTracker-2026/Tests/7802-select-with-subqueries.test --- a/sql/test/BugTracker-2026/Tests/7802-select-with-subqueries.test +++ b/sql/test/BugTracker-2026/Tests/7802-select-with-subqueries.test @@ -1,3 +1,8 @@ +onlyif has-hugeint statement error 42000!types decimal(34,24) and boolean(1,0) are not equal for column 'x' SELECT ( WITH x AS ( WITH RECURSIVE x ( x ) AS ( SELECT FALSE >= 1 BETWEEN 1 AND 1 UNION SELECT 0.100000 * 0.100000 * 0.100000 * 0.100000 * ( WITH x AS ( WITH RECURSIVE x ( x ) AS ( SELECT FALSE >= 1 BETWEEN 1 AND 1 UNION SELECT x + 1 FROM x ) SELECT * FROM x EXCEPT SELECT * FROM x ) SELECT CASE WHEN NULL IN ( 69 , MAX ( CASE WHEN 97 THEN 66 END ) OVER ( ) + ( SELECT COUNT ( * ) ) ) THEN 41 END FROM x ) FROM x ) SELECT * FROM x EXCEPT SELECT * FROM x ) SELECT CASE WHEN NULL IN ( 69 , MAX ( CASE WHEN 97 THEN 66 END ) OVER ( ) + ( SELECT COUNT ( * ) ) ) THEN 41 END FROM x ) +skipif has-hugeint +statement error 42000!types decimal(18,17) and boolean(1,0) are not equal for column 'x' +SELECT ( WITH x AS ( WITH RECURSIVE x ( x ) AS ( SELECT FALSE >= 1 BETWEEN 1 AND 1 UNION SELECT 0.100000 * 0.100000 * 0.100000 * 0.100000 * ( WITH x AS ( WITH RECURSIVE x ( x ) AS ( SELECT FALSE >= 1 BETWEEN 1 AND 1 UNION SELECT x + 1 FROM x ) SELECT * FROM x EXCEPT SELECT * FROM x ) SELECT CASE WHEN NULL IN ( 69 , MAX ( CASE WHEN 97 THEN 66 END ) OVER ( ) + ( SELECT COUNT ( * ) ) ) THEN 41 END FROM x ) FROM x ) SELECT * FROM x EXCEPT SELECT * FROM x ) SELECT CASE WHEN NULL IN ( 69 , MAX ( CASE WHEN 97 THEN 66 END ) OVER ( ) + ( SELECT COUNT ( * ) ) ) THEN 41 END FROM x ) + _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
