Changeset: d2a9f17a79ea for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d2a9f17a79ea Added Files: sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-in.Bug-6410.sql Modified Files: sql/test/BugTracker-2017/Tests/All sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-not-in.Bug-6409.sql Branch: Jul2017 Log Message:
Added test for bug 6410 diffs (23 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 @@ -72,3 +72,4 @@ copy_into_crash.Bug-6404 null_matches_in_outer.Bug-6398 corr_coersion.Bug-6287 sqlitelogictest-having-with-not-in.Bug-6409 +sqlitelogictest-having-with-in.Bug-6410 diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-in.Bug-6410.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-in.Bug-6410.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-in.Bug-6410.sql @@ -0,0 +1,3 @@ +CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER); +SELECT 9 - - col1 FROM tab2 GROUP BY col1 HAVING - CAST ( NULL AS INTEGER ) IN ( + - SUM ( - + 47 ), + MIN ( col2 ) ); +DROP TABLE tab2; diff --git a/sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-not-in.Bug-6409.sql b/sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-not-in.Bug-6409.sql --- a/sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-not-in.Bug-6409.sql +++ b/sql/test/BugTracker-2017/Tests/sqlitelogictest-having-with-not-in.Bug-6409.sql @@ -1,2 +1,3 @@ CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER); SELECT cor0.col1 FROM tab1 AS cor0 GROUP BY cor0.col1 HAVING NULL NOT IN ( - cor0.col1 ); +DROP TABLE tab1; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
