Changeset: add2bc53a31b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/add2bc53a31b Added Files: sql/test/BugTracker-2024/Tests/CMDgen_group-Bug-7486.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for bug #7486 diffs (32 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 @@ -46,3 +46,4 @@ bin_find_smallest_column-Bug-7482 rel_setop_get_statistics-Bug-7483 rel_groupby_cse-Bug-7484 rel_groupby_cse-Bug-7485 +CMDgen_group-Bug-7486 diff --git a/sql/test/BugTracker-2024/Tests/CMDgen_group-Bug-7486.test b/sql/test/BugTracker-2024/Tests/CMDgen_group-Bug-7486.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/CMDgen_group-Bug-7486.test @@ -0,0 +1,19 @@ +query I nosort +WITH x AS ( SELECT * FROM generate_series ( 32989 , 8100 ) EXCEPT SELECT * FROM generate_series ( 44 , 3 ) ) SELECT CASE WHEN NULL IN ( 69 ) THEN 41 END FROM x LIMIT 3 +---- +NULL +NULL +NULL + +query I nosort +WITH x AS ( SELECT * FROM generate_series ( 32989 , 8100 ) EXCEPT SELECT * FROM generate_series ( 44 , 3 ) ) SELECT CASE WHEN NULL IN ( 69 , MAX ( CASE WHEN 97 THEN 66 END ) OVER ( ) + ( SELECT COUNT ( * ) ) ) THEN 41 END FROM x LIMIT 3 +---- +NULL +NULL +NULL + +skipif knownfail +query I nosort +SELECT ( WITH x AS ( SELECT * FROM generate_series ( 32989 , 8100 ) EXCEPT SELECT * FROM generate_series ( 44 , 3 ) ) SELECT CASE WHEN NULL IN ( 69 , MAX ( CASE WHEN 97 THEN 66 END ) OVER ( ) + ( SELECT COUNT ( * ) ) ) THEN 41 END FROM x ) +---- + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
