Changeset: 9ca9369441c5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9ca9369441c5 Added Files: sql/test/BugTracker-2024/Tests/exp_equal-Bug-7475.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for bug #7475 diffs (44 lines): diff --git a/sql/test/BugTracker-2024/Tests/All b/sql/test/BugTracker-2024/Tests/All --- a/sql/test/BugTracker-2024/Tests/All +++ b/sql/test/BugTracker-2024/Tests/All @@ -35,3 +35,4 @@ conversion-string-to-bte-failed-7470 groupby-select1-Bug-7472 SQLunionfunc-Bug-7473 VLTgenerator_table-Bug-7474 +exp_equal-Bug-7475 diff --git a/sql/test/BugTracker-2024/Tests/exp_equal-Bug-7475.test b/sql/test/BugTracker-2024/Tests/exp_equal-Bug-7475.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/exp_equal-Bug-7475.test @@ -0,0 +1,31 @@ +query II nosort +WITH x AS ( SELECT 1 x ) SELECT 1 , ( SELECT x FROM x ) FROM x WHERE x +---- +1 +1 + +query II nosort +WITH x AS ( SELECT 1 x ) SELECT 1 , ( SELECT x FROM x ) FROM ( x NATURAL JOIN x ) WHERE x +---- +1 +1 + +skipif knownfail +query II nosort +SELECT * FROM ( WITH x AS ( SELECT 1 x ) SELECT 1 , ( SELECT x FROM x ) FROM x WHERE x ) y +---- +1 +1 + +query II nosort +SELECT * FROM ( WITH x AS ( SELECT 1 x ) SELECT 1 , x FROM ( x NATURAL JOIN x ) WHERE x ) y +---- +1 +1 + +skipif knownfail +query II nosort +SELECT * FROM ( WITH x AS ( SELECT 1 x ) SELECT 1 , ( SELECT x FROM x ) FROM ( x NATURAL JOIN x ) WHERE x ) y +---- +1 +1 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
