Changeset: 9a05add39d7b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9a05add39d7b Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-select-range-null.Bug-6514.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-aggregation-count.Bug-6510.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-mal-function-generation.Bug-6513.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.sql Removed Files: sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-aggregation-count.Bug-6510.sql sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.sql Modified Files: sql/test/BugTracker-2017/Tests/All sql/test/BugTracker-2018/Tests/All Branch: Jul2017 Log Message:
Added tests for bugs 6513 and 6514 diffs (51 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,5 +109,3 @@ 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 -sqlitelogictest-wrong-select-not-between.Bug-6511 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 @@ -1,1 +1,5 @@ HAVE_LIBPY?pyUDF-crash.Bug-6508 +sqlitelogictest-wrong-aggregation-count.Bug-6510 +sqlitelogictest-wrong-select-not-between.Bug-6511 +sqlitelogictest-wrong-mal-function-generation.Bug-6513 +sqlitelogictest-select-range-null.Bug-6514 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-range-null.Bug-6514.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-range-null.Bug-6514.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-range-null.Bug-6514.sql @@ -0,0 +1,11 @@ +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 col1 FROM tab1 WHERE NULL <= NULL; +SELECT ALL col1 FROM tab1 WHERE NULL < NULL; +SELECT ALL col1 FROM tab1 WHERE NULL > NULL; +SELECT ALL col1 FROM tab1 WHERE NULL >= NULL; +SELECT ALL col1 FROM tab1 WHERE NULL <> NULL; +SELECT ALL col1 FROM tab1 WHERE NULL = NULL; +DROP TABLE tab1; diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-aggregation-count.Bug-6510.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-aggregation-count.Bug-6510.sql rename from sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-aggregation-count.Bug-6510.sql rename to sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-aggregation-count.Bug-6510.sql diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-mal-function-generation.Bug-6513.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-mal-function-generation.Bug-6513.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-mal-function-generation.Bug-6513.sql @@ -0,0 +1,6 @@ +CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab0 VALUES(97,1,99); +INSERT INTO tab0 VALUES(15,81,47); +INSERT INTO tab0 VALUES(87,21,10); +SELECT DISTINCT - + col2 * 68 * - + 22 FROM tab0 AS cor0; +DROP TABLE tab0; diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.sql rename from sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.sql rename to sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.sql _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list