Lines Matching refs:CASE
192 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} no
194 {CASE WHEN i1 IS NOT DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} no
196 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} yes
198 {CASE WHEN i1 IS NOT DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} yes
200 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} no
202 {CASE WHEN i1 IS NOT DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} no
204 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} yes
206 {CASE WHEN i1 IS NOT DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} yes
216 {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} yes
218 {CASE WHEN i1 IS DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} yes
220 {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} no
222 {CASE WHEN i1 IS DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} no
224 {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} yes
226 {CASE WHEN i1 IS DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} yes
228 {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} no
230 {CASE WHEN i1 IS DISTINCT FROM i2 THEN 'yes' ELSE 'no' END} no
707 {CASE WHEN i1 = i2 THEN 'eq' ELSE 'ne' END} ne
709 {CASE WHEN i1 = i2 THEN 'eq' ELSE 'ne' END} eq
711 {CASE WHEN i1 = i2 THEN 'eq' ELSE 'ne' END} ne
713 {CASE WHEN i1 = i2 THEN 'eq' ELSE 'ne' END} ne
715 {CASE i1 WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 'error' END} two
717 {CASE i1 WHEN 1 THEN 'one' WHEN NULL THEN 'two' ELSE 'error' END} one
719 {CASE i1 WHEN 1 THEN 'one' WHEN NULL THEN 'two' ELSE 'error' END} error
721 {CASE i1 WHEN 1 THEN 'one' WHEN NULL THEN 'two' ELSE 'error' END} error
723 {CASE i1 WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 'error' END} error
725 {CASE i1 WHEN 1 THEN 'one' WHEN 2 THEN 'two' END} {{}}
727 {CASE i1 WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 3 END} 3
729 {CASE i1 WHEN 1 THEN null WHEN 2 THEN 'two' ELSE 3 END} {{}}
731 { CASE WHEN i1 < 5 THEN 'low'
936 SELECT (CASE a>4 THEN 1 ELSE 0 END) FROM test1;
941 SELECT (CASE WHEN a>4 THEN 1 ELSE 0) FROM test1;
1012 WHERE (x OR (8==9)) != (CASE WHEN x THEN 1 ELSE 0 END);
1023 SELECT sum(CASE WHEN x THEN 0 ELSE 1 END) FROM t1
1045 WHERE (x OR (8==9)) != (CASE WHEN x THEN 1 ELSE 0 END);
1059 SELECT sum(CASE WHEN x THEN 0 ELSE 1 END) FROM t1