Changeset: ff8bda80d298 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ff8bda80d298 Added Files: sql/test/BugTracker-2018/Tests/sqlitelogictest-select-nullif-case.Bug-6579.sql Modified Files: sql/test/BugTracker-2018/Tests/All Branch: default Log Message:
Added test for Bug 6579 diffs (15 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 @@ -51,3 +51,4 @@ create-temp-table-ordered-index-error.Bu sqlitelogictest-missing-bulk-implementation.Bug-6575 sqlitelogictest-aritmetic-expressions-handling.Bug-6576 multiple-insertinto-table-Bug-6578 +sqlitelogictest-select-nullif-case.Bug-6579 diff --git a/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-nullif-case.Bug-6579.sql b/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-nullif-case.Bug-6579.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2018/Tests/sqlitelogictest-select-nullif-case.Bug-6579.sql @@ -0,0 +1,2 @@ +SELECT ALL - 70 + + - 89 - + ( SUM ( + CASE - NULLIF ( + 87, CASE CAST ( NULL AS INTEGER ) WHEN 13 / + ( 68 * - ( 64 ) ) +THEN + 39 WHEN 70 * - 95 THEN 60 ELSE 15 + + 25 END * 5 ) WHEN + 36 THEN NULL WHEN 24 THEN NULL ELSE 66 END ) ) AS col2; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
