Changeset: 3d050eebe253 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3d050eebe253 Added Files: sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-aggregation-count.Bug-6510.sql Modified Files: sql/test/BugTracker-2017/Tests/All Branch: Jul2017 Log Message:
Added test for bug 6510 diffs (19 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 @@ -109,3 +109,4 @@ sqlitelogictest-comparisons-between-floa sqlitelogictest-not-between.Bug-6497 createorreplace-system-func.Bug-6499 crash-on-limit-rename.Bug-6502 +sqlitelogictest-wrong-aggregation-count.Bug-6510.sql diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-aggregation-count.Bug-6510.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-aggregation-count.Bug-6510.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-aggregation-count.Bug-6510.sql @@ -0,0 +1,6 @@ +CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab1 VALUES(51,14,96); +INSERT INTO tab1 VALUES(85,5,59); +INSERT INTO tab1 VALUES(91,47,68); +SELECT ALL COUNT ( DISTINCT - 34 ) * - COUNT ( * ) AS col2 FROM tab1 WHERE + col1 IS NULL; +DROP TABLE tab1; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
