Changeset: 63944bc2d4a4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=63944bc2d4a4 Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: Jul2017 Log Message:
Added tests for bugs 6518 and 6519 (enough bugs for some time) diffs (34 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 @@ -1,5 +1,5 @@ HAVE_LIBPY?pyUDF-crash.Bug-6508 -sqlitelogictest-wrong-aggregation-count.Bug-6510 +HAVE_HGE?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 @@ -7,3 +7,5 @@ insert-null-second-interval-0.Bug-6515 case_with_orderby_limit.Bug-6512 sqlitelogictest-bat-undefined.Bug-6516 sqlitelogictest-overflow-in-conversion.Bug-6517 +sqlitelogictest-count-not-in.Bug-6518 +sqlitelogictest-algebra-join-not-in.Bug-6519 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-algebra-join-not-in.Bug-6519.sql @@ -0,0 +1,4 @@ +CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23); +SELECT * FROM tab2 WHERE col2 NOT IN ( - + col1, col2 * + col1, + - col0 * + + 36, + + col2, 84 * + + col0 ) AND NOT NULL IS NULL; +DROP TABLE tab2; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-count-not-in.Bug-6518.sql @@ -0,0 +1,4 @@ +CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23); +SELECT DISTINCT - 15 * - 19 + - COUNT ( * ) * + 70 FROM tab2 WHERE ( col2 ) NOT IN ( + 12 + col0 ); +DROP TABLE tab2; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
