Changeset: 7582f0753563 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7582f0753563 Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-case-coalesce.Bug-6550.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-cast-null.Bug-6551.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: Mar2018 Log Message:
Added tests for bugs 6550 and 6551 diffs (21 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 @@ -28,3 +28,5 @@ truncate_empty_table.Bug-6544 sqlitelogictest-in-query.Bug-6545 sqlitelogictest-in-with-division.Bug-6546 ilike.Bug-6547 +sqlitelogictest-case-coalesce.Bug-6550 +sqlitelogictest-wrong-cast-null.Bug-6551 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-case-coalesce.Bug-6550.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-case-coalesce.Bug-6550.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-case-coalesce.Bug-6550.sql @@ -0,0 +1,1 @@ +SELECT ALL CASE WHEN NOT NULL NOT IN ( - COALESCE ( + - CAST ( + 45 AS INTEGER ), - 66, - 9 * COALESCE ( 80, NULLIF ( - 12, + + ( + 26 ) + - - MAX ( 18 ) + 66 + 98 ) + + + AVG ( ALL 35 ), - - 55 - - - 67, + 42 ) ), + COUNT ( * ) * - + 23, + 66 * + 93 + - ( - 61 ) + + 10 * + 92 * + - 40 * - 47 / 29, COUNT ( * ) * 30 / 28 + 73 ) THEN COUNT ( * ) / - - 86 ELSE NULL END - - 66; diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-cast-null.Bug-6551.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-cast-null.Bug-6551.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-wrong-cast-null.Bug-6551.sql @@ -0,0 +1,1 @@ +SELECT 0 * + 77 * CAST ( NULL AS INTEGER ) AS col2; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
