Changeset: a9650a8638eb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a9650a8638eb Added Files: sql/test/BugTracker-2024/Tests/rel2bin_join-Bug-7476.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for bug #7476 diffs (52 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 @@ -36,3 +36,4 @@ groupby-select1-Bug-7472 SQLunionfunc-Bug-7473 VLTgenerator_table-Bug-7474 exp_equal-Bug-7475 +rel2bin_join-Bug-7476 diff --git a/sql/test/BugTracker-2024/Tests/rel2bin_join-Bug-7476.test b/sql/test/BugTracker-2024/Tests/rel2bin_join-Bug-7476.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/rel2bin_join-Bug-7476.test @@ -0,0 +1,39 @@ +-- using "SELECT 1" instead of "SELECT DISTINCT 1" +query I nosort +WITH x ( x ) AS ( SELECT 1 ) SELECT ( SELECT x FROM x WHERE x = ( SELECT ( CASE WHEN x THEN x END ) WHERE x = x AND x GROUP BY 1 ) ) FROM x +---- +1 + +query I nosort +WITH x ( x ) AS ( SELECT 1 ) SELECT ( SELECT x FROM x WHERE x = ( SELECT ( CASE WHEN x THEN x END ) WHERE x = ( SELECT x FROM x ) AND x GROUP BY 1 ) ) FROM x +---- +1 + +query I nosort +SELECT ( WITH x ( x ) AS ( SELECT 1 ) SELECT ( SELECT x FROM x WHERE x = ( SELECT ( CASE WHEN x THEN x END ) WHERE x = ( SELECT x FROM x ) AND x GROUP BY 1 ) ) FROM x ) +---- +1 + +-- replacing "CASE WHEN x THEN x END" with "x" +query I nosort +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE x = ( SELECT ( x ) WHERE x = ( SELECT x FROM x ) AND x GROUP BY 1 ) ) FROM x +---- +1 + +query I nosort +SELECT ( WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE x = ( SELECT ( x ) WHERE x = ( SELECT x FROM x ) AND x GROUP BY 1 ) ) FROM x ) +---- +1 + +-- the combination leads to crash in rel2bin_join () +skipif knownfail +query I nosort +WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE x = ( SELECT ( CASE WHEN x THEN x END ) WHERE x = ( SELECT x FROM x ) AND x GROUP BY 1 ) ) FROM x +---- +1 + +skipif knownfail +query I nosort +SELECT ( WITH x ( x ) AS ( SELECT DISTINCT 1 ) SELECT ( SELECT x FROM x WHERE x = ( SELECT ( CASE WHEN x THEN x END ) WHERE x = ( SELECT x FROM x ) AND x GROUP BY 1 ) ) FROM x ) +---- +1 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
