Changeset: ce9b9c9ea18b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ce9b9c9ea18b Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-distinct-duplicate.Bug-6603.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: Mar2018 Log Message:
Added test for bug 6603 diffs (18 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 @@ -59,3 +59,4 @@ multiple-count.Bug-6599 sqlitelogictest-select-errors.Bug-6600 remote-table-where-is-null.Bug-6601 sqlitelogictest-select-not-in-wrong.Bug-6602 +sqlitelogictest-groupby-distinct-duplicate.Bug-6603 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-distinct-duplicate.Bug-6603.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-distinct-duplicate.Bug-6603.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-distinct-duplicate.Bug-6603.sql @@ -0,0 +1,5 @@ +START TRANSACTION; +CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab0 VALUES(83,0,38),(26,0,79),(43,81,24); +SELECT DISTINCT + + col1, col1 FROM tab0 AS cor0 GROUP BY col0, col1 HAVING NOT NULL IS NOT NULL; +ROLLBACK; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
