Changeset: 274f9e4a3a17 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/274f9e4a3a17 Added Files: sql/test/BugTracker-2026/Tests/7802-select-with-subqueries.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7802 diffs (19 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 new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7802-select-with-subqueries.test @@ -0,0 +1,3 @@ +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 ) + 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 @@ -25,6 +25,7 @@ KNOWNFAIL?7795-assertion-failure KNOWNFAIL?7797-assertion-failure KNOWNFAIL?7800-assertion-failure KNOWNFAIL?7801-assertion-failure +7802-select-with-subqueries 7804-querylog-catalog-orderby-bug 7805-orderby-all-bug 7806-numeric-no-prec-no-scale _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
