Changeset: 72b67b7c5393 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/72b67b7c5393 Added Files: sql/test/BugTracker-2026/Tests/7853-in-rcte-generator.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
added test for 7853 diffs (16 lines): diff --git a/sql/test/BugTracker-2026/Tests/7853-in-rcte-generator.test b/sql/test/BugTracker-2026/Tests/7853-in-rcte-generator.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7853-in-rcte-generator.test @@ -0,0 +1,3 @@ +query II +SELECT - 76 AS x , 5 IN ( SELECT 5 FROM ( SELECT 5 UNION SELECT 3 ) AS x ) AND 6 IN ( SELECT MAX ( x ) , MIN ( x ) , MAX ( x ) , MIN ( x ) , MAX ( x ) , MIN ( x ) ORDER BY 1 , 2 LIMIT 0 OFFSET 0 ) GROUP BY x , x HAVING ( WITH RECURSIVE x ( x ) AS ( SELECT MAX ( DISTINCT '' ) WHERE FALSE ORDER BY x , x , x ) SELECT 1 FROM ( SELECT x , sum ( x ) OVER ( ROWS BETWEEN CASE WHEN 'foo' < 'foobar' THEN 1 ELSE 0 END PRECEDING AND CURRENT ROW ) / 2 WHERE NULL IN ( x ) GROUP BY x , x HAVING x = x OR x = 'x' ) NATURAL LEFT OUTER JOIN ( SELECT x FROM x WHERE x < 1 ORDER BY x ) NATURAL LEFT JOIN x AS x NATURAL JOIN ( SELECT x FROM x WHERE x = 'testviewschm2' ) AS x ) != ( SELECT 1 FROM ( SELECT 1 UNION SELECT 2 UNION SELECT 3 ) AS 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 @@ -53,3 +53,4 @@ KNOWNFAIL?7774-insert-into-renamed-table 7849-assertion-failure 7850-assertion-failure 7851-assertion-failure +7853-in-rcte-generator _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
