Home
last modified time | relevance | path

Searched refs:CASE (Results 1 – 25 of 80) sorted by relevance

1234

/sqlite-3.40.0/ext/fts5/
H A Dfts5_tcl.c270 CASE(0, "xColumnCount") { in xF5tApi()
278 CASE(1, "xRowCount") { in xF5tApi()
296 CASE(3, "xTokenize") { in xF5tApi()
308 CASE(4, "xPhraseCount") { in xF5tApi()
316 CASE(5, "xPhraseSize") { in xF5tApi()
328 CASE(6, "xInstCount") { in xF5tApi()
336 CASE(7, "xInst") { in xF5tApi()
351 CASE(8, "xRowid") { in xF5tApi()
356 CASE(9, "xColumnText") { in xF5tApi()
369 CASE(10, "xColumnSize") { in xF5tApi()
[all …]
/sqlite-3.40.0/test/
H A De_expr.test783 94 "CASE WHEN EXPR1 THEN EXPR2 END"
1163 SELECT CASE WHEN var('a') THEN 'A'
1170 SELECT CASE WHEN var('c') THEN 'C'
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'
1358 SELECT CASE WHEN var('a') THEN 'A'
1376 # second: CASE x WHEN w1 THEN r1 WHEN w2 THEN r2 ELSE r3 END CASE WHEN
[all …]
H A Dcse.test45 SELECT CASE WHEN a==1 THEN b ELSE c END, b, c FROM t1
50 SELECT CASE a WHEN 1 THEN b WHEN 2 THEN c ELSE d END, b, c, d FROM t1
55 SELECT CASE b WHEN 11 THEN -b WHEN 21 THEN -c ELSE -d END, b, c, d FROM t1
60 SELECT CASE b+1 WHEN c THEN d WHEN e THEN f ELSE 999 END, b, c, d FROM t1
65 SELECT CASE WHEN b THEN d WHEN e THEN f ELSE 999 END, b, c, d FROM t1
70 SELECT b, c, d, CASE WHEN b THEN d WHEN e THEN f ELSE 999 END FROM t1
75 SELECT b, c, d, CASE WHEN 0 THEN d WHEN e THEN f ELSE 999 END FROM t1
H A Dexpr.test192 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} no
196 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} yes
200 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} no
204 {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} yes
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
731 { CASE WHEN i1 < 5 THEN 'low'
936 SELECT (CASE a>4 THEN 1 ELSE 0 END) FROM test1;
[all …]
H A Drowvalue8.test11 # Use of row values in CASE statements.
27 SELECT a, CASE (b,c) WHEN (1,2) THEN 'aleph'
36 SELECT a, CASE (b,c,d) WHEN (1,2,3) THEN 'aleph'
48 SELECT x, CASE (SELECT b,c FROM t1 WHERE a=y)
H A Dfuzz4.test27 Col0 TEXT DEFAULT (CASE WHEN 1 IS 3530822107858468864
68 Col0 DEFAULT (CASE x'5d' WHEN 1 THEN
69 CASE CURRENT_TIMESTAMP WHEN 1 THEN 1 ELSE 1 END
70 ELSE CASE WHEN 1 THEN FALSE END END )
H A Dtkt3493.test38 CASE
51 CASE
63 SELECT b.val, CASE WHEN b.val = 1 THEN 'xyz' ELSE b.val END AS col1 FROM b;
70 CASE WHEN b.val = 1 THEN 'xyz' ELSE b.val END AS col1
78 CASE WHEN b.val = '1' THEN 'xyz' ELSE b.val END AS col1
H A Dtrigger3.test30 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE
34 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE
125 SELECT CASE WHEN (old.a = 1) THEN RAISE(IGNORE) END;
129 SELECT CASE WHEN (old.a = 1) THEN RAISE(IGNORE) END;
168 SELECT CASE WHEN (new.a = 1) THEN RAISE(ROLLBACK, 'View rollback')
H A Dcoalesce.test74 CASE WHEN b=2 THEN 123 END,
75 CASE WHEN b=3 THEN 234 END,
76 CASE WHEN c=3 THEN 345 WHEN c=33 THEN 456 END,
H A Djson102.test351 CASE WHEN subtype(x->'a') THEN 'json' ELSE typeof(x->'a') END AS 'type',
353 CASE WHEN subtype(x->>'a') THEN 'json' ELSE typeof(x->>'a') END AS 'type',
355 CASE WHEN subtype(json_extract(x,'$.a'))
374 CASE WHEN subtype(x->y) THEN 'json' ELSE typeof(x->y) END AS 'type',
376 CASE WHEN subtype(x->>y) THEN 'json' ELSE typeof(x->>y) END AS 'type',
378 CASE WHEN subtype(json_extract(x,format('$[%d]',y)))
H A Dtkt3541.test25 SELECT CASE ~max(x) WHEN min(x) THEN 1 ELSE max(x) END FROM t1;
30 SELECT CASE NOT max(x) WHEN min(x) THEN 1 ELSE max(x) END FROM t1;
H A Dcollate2.test272 CASE a WHEN 'aa' THEN 1 ELSE 0 END
279 CASE b WHEN 'aa' THEN 1 ELSE 0 END
286 CASE c WHEN 'aa' THEN 1 ELSE 0 END
419 SELECT a FROM collate2t1 WHERE NOT CASE a WHEN 'aa' THEN 1 ELSE 0 END;
424 SELECT b FROM collate2t1 WHERE NOT CASE b WHEN 'aa' THEN 1 ELSE 0 END;
429 SELECT c FROM collate2t1 WHERE NOT CASE c WHEN 'aa' THEN 1 ELSE 0 END;
561 SELECT CASE a WHEN 'aa' THEN 1 ELSE 0 END FROM collate2t1;
566 SELECT CASE b WHEN 'aa' THEN 1 ELSE 0 END FROM collate2t1;
571 SELECT CASE c WHEN 'aa' THEN 1 ELSE 0 END FROM collate2t1;
H A Dtrans2.test161 z = CASE WHEN id<$max_rowid
185 z = CASE WHEN id<$max1
215 z = CASE WHEN id<$max1
221 z = CASE WHEN id<$max1
H A Dtkt-fa7bf5ec.test33 SELECT count(CASE WHEN x='a' THEN 1 END),
34 count(CASE WHEN x='A' THEN 1 END)
H A Dcollate8.test146 SELECT 'abc'==('ABC'||CASE WHEN 1-1=2 THEN '' COLLATE nocase
148 SELECT 'abc'==('ABC'||CASE WHEN 1+1=2 THEN '' COLLATE nocase
152 SELECT 'abc'==('ABC'||CASE WHEN 1=2 THEN '' COLLATE binary
H A Dtkt1567.test41 UPDATE t1 SET a = CASE WHEN rowid<90 THEN substr(a,1,10) ELSE '9999' END;
72 UPDATE t2 SET a = CASE WHEN rowid<90 THEN substr(a,1,10) ELSE '9999' END;
H A DmallocH.test33 # Malloc failures while parsing a CASE expression.
36 SELECT CASE WHEN 1 THEN 1 END;
H A Dfuzz-oss1.test132 CREATE TRIGGER cpt_node_fullname1 AFTER INSERT ON node BEGIN UPDATE node SET t_fullname=CASE WHEN n…
242 …CASE WHEN unit.rd_unit_id=0 THEN '' ELSE (SELECT (CASE WHEN s.t_symbol!='' THEN s.t_symbol ELSE s.…
243 CREATE VIEW v_unit_tmp2 AS SELECT *,CASE WHEN v_unit_tmp1.t_type='1' THEN 1 ELSE IFNULL((SELECT s.f…
252 …|' '||IFNULL(t_PAYEE,'')||' '||v_operation.f_CURRENTAMOUNT||' '||(SELECT (CASE WHEN s.t_symbol!=''…
253 CREATE VIEW v_operation_delete AS SELECT *, (CASE WHEN t_status='Y' THEN 'Vous n''êtes pas autorisé…
261 CREATE VIEW v_recurrentoperation AS SELECT *,i_period_increment||' '||(CASE t_period_unit WHEN 'Y' …
264 …und_id),'') AS t_REFUND, (CASE WHEN v_suboperation.f_value>=0 THEN v_suboperation.f_value ELSE 0 E…
266 …CASE WHEN s.t_symbol!='' THEN s.t_symbol ELSE s.t_name END) FROM unit s WHERE s.id=v_operation.rc_…
273 CREATE VIEW v_refund_delete AS SELECT *, (CASE WHEN EXISTS(SELECT 1 FROM v_operation_consolidated W…
277 CREATE VIEW v_payee_delete AS SELECT *, (CASE WHEN EXISTS(SELECT 1 FROM operation WHERE r_payee_id=…
[all …]
H A Dmisc3.test39 catchsql {UPDATE t1 SET a=CASE a WHEN 2 THEN 1 ELSE a END, b='y';}
67 catchsql {UPDATE t1 SET a=CASE a WHEN 128 THEN 127 ELSE a END, b='';}
345 SELECT count(CASE WHEN b IN ('abc','xyz') THEN 'x' END) FROM t3
H A Dselect2.test176 SELECT * FROM aa, bb WHERE CASE WHEN a=b-1 THEN 1 END;
181 SELECT * FROM aa, bb WHERE CASE WHEN a=b-1 THEN 0 ELSE 1 END;
H A Djoin.test841 # sqlite3ExprImpliesNotNull() routine was saying that CASE expressions
844 # CASE WHEN true THEN true ELSE x=0 END
857 WHERE CASE WHEN FALSE THEN a=x ELSE 1 END;
893 ON x2<=CASE WHEN x1 THEN CASE WHEN a2 THEN 1 ELSE -1 END ELSE 0 END
897 ON x3<=CASE WHEN x2 THEN CASE WHEN a3 THEN 1 ELSE -1 END ELSE 0 END
901 ON x4<=CASE WHEN x3 THEN CASE WHEN a4 THEN 1 ELSE -1 END ELSE 0 END
H A Dwith2.test492 rsx * 1.2 * IFNULL(CASE WHEN (
499 rsy * 1.2 * IFNULL(CASE WHEN (
518 SELECT m, mi, xorigin, yorigin + CASE
525 SELECT m, mi, xorigin + rsx / 2, yorigin + (CASE
H A Dselect7.test170 SELECT (CASE WHEN a=0 THEN 0 ELSE (a + 25) / 50 END) AS categ, count(*)
183 SELECT (CASE WHEN a=0 THEN 'zero' ELSE a/2 END) AS t FROM t4 GROUP BY t;
H A Dcheckfault.test24 CASE 'abc' COLLATE nocase WHEN a THEN 1 ELSE 0 END)
H A Dtkt3461.test50 WHERE CASE WHEN a=1 THEN 1 ELSE b_plus_one END

1234