Lines Matching refs:CASE
778 89 "CASE EXPR WHEN EXPR1 THEN EXPR2 ELSE EXPR END"
779 90 "CASE EXPR WHEN EXPR1 THEN EXPR2 END"
780 91 "CASE EXPR WHEN EXPR1 THEN EXPR2 WHEN EXPR THEN EXPR1 ELSE EXPR2 END"
781 92 "CASE EXPR WHEN EXPR1 THEN EXPR2 WHEN EXPR THEN EXPR1 END"
782 93 "CASE WHEN EXPR1 THEN EXPR2 ELSE EXPR END"
783 94 "CASE WHEN EXPR1 THEN EXPR2 END"
784 95 "CASE WHEN EXPR1 THEN EXPR2 WHEN EXPR THEN EXPR1 ELSE EXPR2 END"
785 96 "CASE WHEN EXPR1 THEN EXPR2 WHEN EXPR THEN EXPR1 END"
1138 # Test cases for the testable statements related to the CASE expression.
1140 # EVIDENCE-OF: R-57495-24088 There are two fundamental forms of the CASE
1144 SELECT CASE WHEN 1 THEN 'true' WHEN 0 THEN 'false' ELSE 'else' END;
1147 SELECT CASE 0 WHEN 1 THEN 'true' WHEN 0 THEN 'false' ELSE 'else' END;
1156 # EVIDENCE-OF: R-30638-59954 In a CASE without a base expression, each
1163 SELECT CASE WHEN var('a') THEN 'A'
1170 SELECT CASE WHEN var('c') THEN 'C'
1178 # EVIDENCE-OF: R-39009-25596 The result of the CASE expression is the
1184 SELECT CASE WHEN var('a') THEN 'A'
1192 SELECT CASE WHEN var('a') THEN 'A'
1200 SELECT CASE WHEN var('a') THEN 'A'
1213 SELECT CASE WHEN var('a') THEN 'A'
1225 SELECT CASE WHEN var('a') THEN 'A'
1236 SELECT CASE WHEN NULL THEN 'A' WHEN 1 THEN 'B' END, iif(NULL,8,99);
1239 SELECT CASE WHEN 0 THEN 'A' WHEN NULL THEN 'B' ELSE 'C' END, iif(0,8,99);
1242 # EVIDENCE-OF: R-38620-19499 In a CASE with a base expression, the base
1253 SELECT CASE var('a') WHEN 1 THEN 'A' WHEN 2 THEN 'B' WHEN 3 THEN 'C' END
1257 # EVIDENCE-OF: R-07667-49537 The result of the CASE expression is the
1262 SELECT CASE 23 WHEN 1 THEN 'A' WHEN 23 THEN 'B' WHEN 23 THEN 'C' END
1265 SELECT CASE 1 WHEN 1 THEN 'A' WHEN 23 THEN 'B' WHEN 23 THEN 'C' END
1273 SELECT CASE 24 WHEN 1 THEN 'A' WHEN 23 THEN 'B' WHEN 23 THEN 'C' ELSE 'D' END
1281 SELECT CASE 24 WHEN 1 THEN 'A' WHEN 23 THEN 'B' WHEN 23 THEN 'C' END
1285 SELECT CASE 24 WHEN 1 THEN 'A' WHEN 23 THEN 'B' WHEN 23 THEN 'C' END
1317 SELECT CASE a WHEN 'xyz' THEN 'A' WHEN 'AbC' THEN 'B' END FROM t1
1320 SELECT CASE 'AbC' WHEN 'abc' THEN 'A' WHEN a THEN 'B' END FROM t1
1323 SELECT CASE a WHEN b THEN 'A' ELSE 'B' END FROM t1
1326 SELECT CASE b WHEN a THEN 'A' ELSE 'B' END FROM t1
1329 SELECT CASE 55 WHEN '55' THEN 'A' ELSE 'B' END
1332 SELECT CASE c WHEN '55' THEN 'A' ELSE 'B' END FROM t1
1335 SELECT CASE '34.5' WHEN d THEN 'A' ELSE 'B' END FROM t1
1338 SELECT CASE NULL WHEN NULL THEN 'A' ELSE 'B' END
1342 # result of the CASE is always the result of evaluating the ELSE
1346 SELECT CASE NULL WHEN 'abc' THEN 'A' WHEN 'def' THEN 'B' END;
1349 SELECT CASE NULL WHEN 'abc' THEN 'A' WHEN 'def' THEN 'B' ELSE 'C' END;
1352 # EVIDENCE-OF: R-56280-17369 Both forms of the CASE expression use lazy,
1358 SELECT CASE WHEN var('a') THEN 'A'
1366 SELECT CASE '0' WHEN var('a') THEN 'A'
1374 # two CASE expressions is that the x expression is evaluated exactly
1376 # second: CASE x WHEN w1 THEN r1 WHEN w2 THEN r2 ELSE r3 END CASE WHEN
1393 SELECT CASE x WHEN w1 THEN r1 WHEN w2 THEN r2 ELSE r3 END FROM t2
1396 SELECT CASE WHEN x=w1 THEN r1 WHEN x=w2 THEN r2 ELSE r3 END FROM t2
1400 SELECT CASE ceval(x) WHEN w1 THEN r1 WHEN w2 THEN r2 ELSE r3 END FROM t2
1405 SELECT CASE
1953 SELECT CASE WHEN NULL THEN 'true' ELSE 'false' END, iif(NULL,'true','false');
1956 SELECT CASE WHEN 0.0 THEN 'true' ELSE 'false' END, iif(0.0,'true','false');
1959 SELECT CASE WHEN 0 THEN 'true' ELSE 'false' END, iif(0,'true','false');
1962 SELECT CASE WHEN 'engligh' THEN 'true' ELSE 'false' END, iif('engligh','true','false');
1965 SELECT CASE WHEN '0' THEN 'true' ELSE 'false' END, iif('0','true','false');
1972 SELECT CASE WHEN 1 THEN 'true' ELSE 'false' END, iif(1,'true','false');
1975 SELECT CASE WHEN 1.0 THEN 'true' ELSE 'false' END, iif(1.0,'true','false');
1978 SELECT CASE WHEN 0.1 THEN 'true' ELSE 'false' END, iif(0.1,'true','false');
1981 SELECT CASE WHEN -0.1 THEN 'true' ELSE 'false' END, iif(-0.1,'true','false');
1984 SELECT CASE WHEN '1english' THEN 'true' ELSE 'false' END, iif('1engl','true','false');