Changeset: 265c2bacd276 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=265c2bacd276 Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-select-not-in-wrong.Bug-6602.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: Mar2018 Log Message:
Added test for bug 6602 diffs (17 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 @@ -58,3 +58,4 @@ sqlitelogictest-complex-case-not-in.Bug- multiple-count.Bug-6599 sqlitelogictest-select-errors.Bug-6600 remote-table-where-is-null.Bug-6601 +sqlitelogictest-select-not-in-wrong.Bug-6602 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-not-in-wrong.Bug-6602.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-not-in-wrong.Bug-6602.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-not-in-wrong.Bug-6602.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 ( + - 59 + + ( 76 ), col1, + CAST ( NULL AS INTEGER ), col1, - 19, col1 ); +DROP TABLE tab2; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
