Skip to content

Commit 7765229

Browse files
committed
Add additional SLTs covering ExpressionOrExpression
1 parent 0cf3156 commit 7765229

1 file changed

Lines changed: 32 additions & 0 deletions

File tree

  • datafusion/sqllogictest/test_files

‎datafusion/sqllogictest/test_files/case.slt‎

Lines changed: 32 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -642,6 +642,38 @@ NULL
642642
NULL
643643
-1
644644

645+
# single WHEN, no ELSE (absent)
646+
query I
647+
SELECT CASE WHEN a > 0 THEN b END
648+
FROM (VALUES (1, 10), (0, 20)) AS t(a, b);
649+
----
650+
10
651+
NULL
652+
653+
# single WHEN, explicit ELSE NULL
654+
query I
655+
SELECT CASE WHEN a > 0 THEN b ELSE NULL END
656+
FROM (VALUES (1, 10), (0, 20)) AS t(a, b);
657+
----
658+
10
659+
NULL
660+
661+
# fallible THEN expression should only be evaluated on true rows
662+
query I
663+
SELECT CASE WHEN a > 0 THEN 10 / a END
664+
FROM (VALUES (1), (0)) AS t(a);
665+
----
666+
10
667+
NULL
668+
669+
# all-false path returns typed NULLs
670+
query I
671+
SELECT CASE WHEN a < 0 THEN b END
672+
FROM (VALUES (1, 10), (2, 20)) AS t(a, b);
673+
----
674+
NULL
675+
NULL
676+
645677
# EvalMethod::WithExpression using subset of all selected columns in case expression
646678
query III
647679
SELECT CASE a1 WHEN 1 THEN a1 WHEN 2 THEN a2 WHEN 3 THEN b END, b, c

0 commit comments

Comments
 (0)