Changeset: 253c7e1776cc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/253c7e1776cc Added Files: sql/test/BugTracker-2024/Tests/groupby-select1-Bug-7472.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for Bug #7472 Issue appears to be in the GROUP BY ( SELECT 1 ) part. When using GROUP BY 1 it works. diffs (23 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 @@ -32,3 +32,4 @@ between-true-and-null-Bug-7465 inner-join-contains-7466 contains-or-7469 conversion-string-to-bte-failed-7470 +groupby-select1-Bug-7472 diff --git a/sql/test/BugTracker-2024/Tests/groupby-select1-Bug-7472.test b/sql/test/BugTracker-2024/Tests/groupby-select1-Bug-7472.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/groupby-select1-Bug-7472.test @@ -0,0 +1,10 @@ +query I nosort +SELECT ( WITH x AS ( SELECT 1 x ) SELECT 1 FROM ( x NATURAL JOIN x ) WHERE x NOT IN ( SELECT CASE WHEN x THEN ( SELECT 1 ) END GROUP BY 1 ) ) +---- +NULL + +skipif knownfail +query I nosort +SELECT ( WITH x AS ( SELECT 1 x ) SELECT 1 FROM ( x NATURAL JOIN x ) WHERE x NOT IN ( SELECT CASE WHEN x THEN ( SELECT 1 ) END GROUP BY ( SELECT 1 ) ) ) +---- +NULL _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
