Changeset: fcb7f82a45e3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fcb7f82a45e3 Added Files: sql/test/BugTracker-2024/Tests/exp_ref-Bug-7479.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for bug #7479 diffs (45 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 @@ -39,3 +39,4 @@ exp_equal-Bug-7475 rel2bin_join-Bug-7476 atom_cmp-Bug-7477 exp_equal-Bug-7478 +exp_ref-Bug-7479 diff --git a/sql/test/BugTracker-2024/Tests/exp_ref-Bug-7479.test b/sql/test/BugTracker-2024/Tests/exp_ref-Bug-7479.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/exp_ref-Bug-7479.test @@ -0,0 +1,32 @@ +query T nosort +WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS +---- +1 +1 + +query T nosort +WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS WHERE x IN ( SELECT x FROM x AS ) +---- +1 +1 + +query IRI nosort +WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS WHERE x IN ( SELECT min ( x ) OVER ( PARTITION BY x ) AS ) +---- +1 +1.000 +1 +1 +-199419.000 +1 + +skipif knownfail +query T nosort +WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS WHERE x IN ( SELECT x FROM x , ( SELECT min ( x ) OVER ( PARTITION BY x ) ) AS ) +---- + +skipif knownfail +query T nosort +SELECT ( WITH x AS ( SELECT 1 x UNION SELECT - '199419' ) SELECT 1 FROM x AS WHERE x IN ( SELECT x FROM x , ( SELECT min ( x ) OVER ( PARTITION BY x ) ) AS ) ) +---- + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
