Changeset: cfe2a4fe1c9d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cfe2a4fe1c9d Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-having-not-null-not-in.Bug-6557.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: Mar2018 Log Message:
Added test for bug 6557 diffs (17 lines): diff --git a/sql/test/BugTracker-2018/Tests/All b/sql/test/BugTracker-2018/Tests/All --- a/sql/test/BugTracker-2018/Tests/All +++ b/sql/test/BugTracker-2018/Tests/All @@ -35,3 +35,4 @@ sqlitelogictest-groupby-having-not-in.Bu sqlitelogictest-nested-case.Bug-6554 sqlitelogictest-complex-case-extra-columns.Bug-6555 sqlitelogictest-coalesce-division-by-zero.Bug-6556 +sqlitelogictest-having-not-null-not-in.Bug-6557 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-having-not-null-not-in.Bug-6557.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-having-not-null-not-in.Bug-6557.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-having-not-null-not-in.Bug-6557.sql @@ -0,0 +1,4 @@ +CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab0 VALUES(83,0,38), (26,0,79), (43,81,24); +SELECT DISTINCT col2 FROM tab0 GROUP BY col2, col1 HAVING NOT NULL NOT IN ( AVG ( ALL + col1 ) ); +DROP TABLE tab0; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
