Changeset: 64a5f2bfdb52 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=64a5f2bfdb52 Added Files: sql/test/BugTracker-2017/Tests/sqlitelogictest-not-between.Bug-6497.sql Modified Files: sql/test/BugTracker-2017/Tests/All Branch: Jul2017 Log Message:
Added test for Bug 6497 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 @@ -105,3 +105,4 @@ sqlitelogictest-min-distinct-empty-table sqlitelogictest-algebra-operators.Bug-6494 sqlitelogictest-hidden-alias.Bug-6495 sqlitelogictest-comparisons-between-floating-points-and-NULL.Bug-6496.sql +sqlitelogictest-not-between.Bug-6497 diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-not-between.Bug-6497.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-not-between.Bug-6497.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-not-between.Bug-6497.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 * FROM tab0 WHERE + col1 NOT BETWEEN col2 + - 99 AND + 20; +DROP TABLE tab0; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
