Changeset: 484ca02b0773 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=484ca02b0773 Added Files: sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.sql Modified Files: sql/test/BugTracker-2017/Tests/All Branch: Jul2017 Log Message:
Added test for Bug 6335 diffs (18 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 @@ -65,3 +65,4 @@ caching_stats_bug.6374 HAVE_LIBPY?aggr_udf_with_more_than_2params.Bug-6385 exists.Bug-6392 case.Bug-6386 +sqllitelogistest_case.Bug-6335 diff --git a/sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.sql b/sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.sql @@ -0,0 +1,5 @@ +SELECT DISTINCT 8 * + + CASE + NULLIF ( - - CASE - ( 52 ) WHEN + 18 - - COUNT ( * ) THEN + 4 WHEN + + 93 - - ( - 40 ) +THEN - - 1 * 27 * MIN ( DISTINCT - 85 ) + - - 29 * - + CASE - CASE - 66 WHEN - + 87 / 51 THEN 25 * 78 END WHEN - 12 * +- 38 / + - 64 * - - CASE - - 61 WHEN + - 84 + 83 + + 36 * NULLIF ( - 46, - 21 ) * 21 + - 18 + - 21 THEN + 8 * 45 WHEN ++ 40 THEN NULL END * 7 THEN NULL WHEN - 8 THEN SUM ( + 62 ) * 44 WHEN - ( - ( + ( 6 ) ) ) THEN + 91 + + 38 ELSE NULL END +END, + 57 ) WHEN - CAST ( NULL AS INTEGER ) THEN ( 46 ) ELSE NULL END * - 77; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list