Changeset: 725d659cb419 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=725d659cb419 Added Files: sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.sql Modified Files: sql/test/BugTracker-2017/Tests/All Branch: Jul2017 Log Message:
Added test for bug 6428 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 @@ -79,3 +79,4 @@ sqlsmith.Bug-6423 sqlsmith.Bug-6424 sqlsmith.Bug-6425 double-groupby-column.Bug-6207 +sqlitelogictest-aggregation-having-avg.Bug-6428 diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-having-avg.Bug-6428.sql @@ -0,0 +1,3 @@ +CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +SELECT - col0 AS col1 FROM tab0 AS cor0 WHERE NOT + col0 IS NOT NULL GROUP BY col1, col0 HAVING NOT - col1 + + AVG ( DISTINCT col0 ) IS NULL; +DROP TABLE tab0; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
