Changeset: 170e20019960 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=170e20019960 Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-cast-null-not-in.Bug-6605.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: Mar2018 Log Message:
Added test for Bug 6605 diffs (47 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 @@ -61,3 +61,4 @@ remote-table-where-is-null.Bug-6601 sqlitelogictest-select-not-in-wrong.Bug-6602 sqlitelogictest-groupby-distinct-duplicate.Bug-6603 procedure-create-table.Bug-6604 +sqlitelogictest-cast-null-not-in.Bug-6605 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-cast-null-not-in.Bug-6605.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-cast-null-not-in.Bug-6605.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-cast-null-not-in.Bug-6605.sql @@ -0,0 +1,34 @@ +START TRANSACTION; + +CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER); +CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER); + +INSERT INTO tab0 VALUES (97,1,99), (15,81,47), (87,21,10); +INSERT INTO tab1 VALUES (51,14,96), (85,5,59), (91,47,68); +INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23); + +SELECT * FROM tab0 cor0 WHERE + col2 + + + 89 + - CAST ( NULL AS REAL ) NOT IN ( 28 * + 37 - ( + col1 ) + + 63, 4, +( ( + - col0 ) ), + col2 ); + +SELECT * FROM tab1 AS cor0 WHERE CAST ( NULL AS INTEGER ) * CAST ( CAST ( + col2 AS INTEGER ) AS INTEGER ) * + + col1 +NOT IN ( + 79 + col1, - col2 ); + +SELECT DISTINCT * FROM tab2 WHERE + col2 / - + CAST ( NULL AS INTEGER ) NOT IN ( + 92 * + col1, 7 ); + +TRUNCATE tab0; +TRUNCATE tab1; +TRUNCATE tab2; + +INSERT INTO tab0 VALUES (97,1,99), (15,81,47), (87,21,10); +INSERT INTO tab1 VALUES (51,14,96), (85,5,59), (91,47,68); +INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23); + +SELECT * FROM tab0 WHERE + col1 * CAST ( NULL AS INTEGER ) NOT IN ( + col2 ); + +SELECT * FROM tab1 AS cor0 WHERE CAST ( + col1 AS INTEGER ) * - 49 NOT IN ( - - CAST ( NULL AS REAL ) * col1, +col2 - + 22, - - 21 ); + +SELECT DISTINCT * FROM tab2 AS cor0 WHERE CAST ( NULL AS INTEGER ) / col2 NOT IN ( 19 / col2 ); + +ROLLBACK; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
