Changeset: 44290b405a9f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=44290b405a9f Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case.Bug-6568.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-undefined-calc.Bug-6570.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: Mar2018 Log Message:
Added tests for bugs 6568, 6569 and 6570 diffs (33 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 @@ -42,3 +42,6 @@ sqlitelogictest-groupby-having-in-cast.B sqlitelogictest-groupby-having-not-null-not-in.Bug-6562 sqlitelogictest-complex-case-nullif-coalesce.Bug-6565 sqlitelogictest-mal-calc-undefined.Bug-6566 +sqlitelogictest-complex-case.Bug-6568 +sqlitelogictest-not-between-wrong.Bug-6569 +sqlitelogictest-undefined-calc.Bug-6570 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case.Bug-6568.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case.Bug-6568.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case.Bug-6568.sql @@ -0,0 +1,3 @@ +SELECT - 76 AS col2, CASE WHEN CAST ( - MAX ( DISTINCT - 75 ) AS INTEGER ) IS NOT NULL THEN + 4 * - + 48 * + 51 * - - +54 * - 77 * 46 WHEN NOT ( NULL ) IN ( + - ( - - 49 ) * - 1, - 41, - 14 - - CASE - - 1 WHEN - - 82 THEN - - 23 END / + 46 +- - 87 * + 52 ) THEN 56 ELSE NULL END AS col2; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-not-between-wrong.Bug-6569.sql @@ -0,0 +1,4 @@ +CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab1 VALUES(51,14,96), (85,5,59), (91,47,68); +SELECT ALL + MIN ( ALL + ( + col0 ) ) + - 9 * - ( + COUNT ( * ) ) AS col0 FROM tab1 AS cor0 WHERE NOT ( - col0 + col0 ) BETWEEN ( - 39 ) AND ( - 92 ); +DROP TABLE tab1; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-undefined-calc.Bug-6570.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-undefined-calc.Bug-6570.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-undefined-calc.Bug-6570.sql @@ -0,0 +1,1 @@ +SELECT ALL 37 * + COALESCE ( - 65, 81 ) * - 36 / + - 36 AS col1; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list