Changeset: 549d90c8aba5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=549d90c8aba5 Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-nullif-coalesce.Bug-6565.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-mal-calc-undefined.Bug-6566.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: Mar2018 Log Message:
Added tests for bugs 6565 and 6566 diffs (27 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 @@ -40,3 +40,5 @@ sqlitelogictest-having-not-null-not-in.B sqlitelogictest-groupby-having-in.Bug-6560 sqlitelogictest-groupby-having-in-cast.Bug-6561 sqlitelogictest-groupby-having-not-null-not-in.Bug-6562 +sqlitelogictest-complex-case-nullif-coalesce.Bug-6565 +sqlitelogictest-mal-calc-undefined.Bug-6566 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-nullif-coalesce.Bug-6565.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-nullif-coalesce.Bug-6565.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-complex-case-nullif-coalesce.Bug-6565.sql @@ -0,0 +1,3 @@ +SELECT + NULLIF ( + 67, + + NULLIF ( + + 46, 66 - CASE WHEN 51 IN ( + 91 ) THEN + SUM ( CAST ( NULL AS INTEGER ) ) ++ - 92 ELSE - ( - 47 ) END ) ) / - CAST ( NULL AS INTEGER ) + + NULLIF ( - COALESCE ( CAST ( - 35 AS INTEGER ), + 6, +COUNT ( ALL 28 ) ), 75 + 14 ); diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-mal-calc-undefined.Bug-6566.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-mal-calc-undefined.Bug-6566.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-mal-calc-undefined.Bug-6566.sql @@ -0,0 +1,5 @@ +CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER); +INSERT INTO tab0 VALUES(97,1,99), (15,81,47), (87,21,10); +SELECT - col0 - - - col0 * + CAST ( NULL AS INTEGER ) FROM tab0; +SELECT ALL - col1 * - 16 * + CAST ( NULL AS INTEGER ) FROM tab0 cor0; +DROP TABLE tab0; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
