Changeset: ab1b5022ce76 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ab1b5022ce76 Added Files: sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-not-in.Bug-6416.sql Modified Files: sql/test/BugTracker-2017/Tests/All Branch: Jul2017 Log Message:
Added test for bug 6416 diffs (16 lines): diff --git a/sql/test/BugTracker-2017/Tests/All b/sql/test/BugTracker-2017/Tests/All --- a/sql/test/BugTracker-2017/Tests/All +++ b/sql/test/BugTracker-2017/Tests/All @@ -74,3 +74,4 @@ corr_coersion.Bug-6287 sqlitelogictest-having-with-not-in.Bug-6409 sqlitelogictest-having-with-in.Bug-6410 sqlitelogictest-aggregation-distinct.Bug-6411 +sqlitelogictest-aggregation-not-in.Bug-6416 diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-not-in.Bug-6416.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-not-in.Bug-6416.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-not-in.Bug-6416.sql @@ -0,0 +1,3 @@ +CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER); +SELECT ALL - 89 FROM tab2 GROUP BY col1, col1 HAVING - CAST ( NULL AS INTEGER ) * + - 17 + + - COUNT ( * ) NOT IN ( + MAX ( 44 ) ); +DROP TABLE tab2; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
