Changeset: 55a1f94dcd75 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/55a1f94dcd75 Added Files: sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7485.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for bug #7486 diffs (34 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 @@ -45,3 +45,4 @@ mvc_row_result_wrap-Bug-7481 bin_find_smallest_column-Bug-7482 rel_setop_get_statistics-Bug-7483 rel_groupby_cse-Bug-7484 +rel_groupby_cse-Bug-7485 diff --git a/sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7485.test b/sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7485.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/rel_groupby_cse-Bug-7485.test @@ -0,0 +1,21 @@ +query I nosort +WITH x ( x ) AS ( SELECT 1 ) SELECT x FROM x GROUP BY x +---- +1 + +statement error 42000!SELECT: cannot use non GROUP BY column 'x' in query results without an aggregate function +WITH x ( x ) AS ( SELECT 1 ) SELECT x FROM x GROUP BY x + 1 +---- + +skipif knownfail +statement error 42000!SELECT: cannot use non GROUP BY column 'x' in query results without an aggregate function +WITH x ( x ) AS ( SELECT 1 ) SELECT x FROM x GROUP BY x + 1 , x + +skipif knownfail +statement error 42000!SELECT: cannot use non GROUP BY column 'x' in query results without an aggregate function +WITH x ( x ) AS ( SELECT 1 ) SELECT ( x ) FROM x WHERE ( SELECT x FROM x GROUP BY x + 1 , x ) + +skipif knownfail +statement error 42000!SELECT: cannot use non GROUP BY column 'x' in query results without an aggregate function +SELECT ( WITH x ( x ) AS ( SELECT 1 ) SELECT ( x ) FROM x WHERE ( SELECT x FROM x GROUP BY x + 1 , x ) ) + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
