Lines Matching refs:b

25     CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, d, e, f);
30     SELECT b, -b, ~b, NOT b, NOT NOT b, b-b, b+b, b*b, b/b, b FROM t1
35     SELECT b, b%b, b==b, b!=b, b<b, b<=b, b IS NULL, b NOT NULL, b FROM t1
40     SELECT b, abs(b), coalesce(b,-b,NOT b,c,NOT c), c, -c FROM t1;
45     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
90     SELECT NOT b, ~b, NOT NOT b, b FROM t1
95     SELECT CAST(b AS integer), typeof(b), CAST(b AS text), typeof(b) FROM t1
108       SELECT coalesce(b,c,d,e), a, b, c, d, e FROM t1 WHERE a=2
110       SELECT coalesce(e,d,c,b), e, d, c, b, a FROM t1 WHERE a=1
116      SELECT upper(b), typeof(b), b FROM t1
121      SELECT b, typeof(b), upper(b), typeof(b), b FROM t1
166   CREATE TABLE t1(a TEXT, b);