Changeset: 524d1efcea88 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=524d1efcea88 Added Files: sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.sql Modified Files: sql/test/BugTracker-2017/Tests/All Branch: Jul2017 Log Message:
Added test for bug 6511 diffs (21 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,4 +109,5 @@ 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 +sqlitelogictest-wrong-aggregation-count.Bug-6510 +sqlitelogictest-wrong-select-not-between.Bug-6511 diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-wrong-select-not-between.Bug-6511.sql @@ -0,0 +1,6 @@ +CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab2 VALUES(64,77,40); +INSERT INTO tab2 VALUES(75,67,58); +INSERT INTO tab2 VALUES(46,51,23); +SELECT ALL - col0 / col0 FROM tab2 cor0 WHERE - col0 NOT BETWEEN ( + col1 + - 0 ) AND ( NULL ); +DROP TABLE tab2; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
