Changeset: 5705171d6574 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5705171d6574 Added Files: sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7484.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for bug #7484 diffs (40 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 @@ -44,3 +44,4 @@ get_rel_count-Bug-7480 mvc_row_result_wrap-Bug-7481 bin_find_smallest_column-Bug-7482 rel_setop_get_statistics-Bug-7483 +rel_groupby_cse-Bug-7484 diff --git a/sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7484.test b/sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7484.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7484.test @@ -0,0 +1,27 @@ +query I nosort +WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM x +---- +1 + +query I nosort +WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM ( SELECT ( CASE WHEN 1 THEN x END ) x , 1 * x FROM x) AS +---- +1 + +skipif knownfail +query I nosort +WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM ( SELECT ( CASE WHEN 1 THEN x END ) x , 1 * x FROM x UNION SELECT 1 , 1 ) AS +---- +1 + +skipif knownfail +query I nosort +WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM x WHERE ( SELECT x FROM ( SELECT ( CASE WHEN 1 THEN x END ) x , 1 * x FROM x UNION SELECT x , x ) AS ) +---- +1 + +skipif knownfail +query I nosort +SELECT ( WITH x AS ( SELECT 1 x UNION SELECT 1 ) SELECT x FROM x WHERE ( SELECT x FROM ( SELECT ( CASE WHEN 1 THEN x END ) x , 1 * x FROM x UNION SELECT x , x ) AS ) ) +---- +1 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
