Lines Matching refs:b
27 CREATE TABLE t1(a INT, b INT, c INT);
28 CREATE INDEX i1 ON t1(a, b);
35 set b [expr int(rand()*20.0) + 1]
36 execsql { INSERT INTO t1 VALUES($a, $b, NULL) }
42 1 "b = 5" {/*ANY(a) AND b=?*/}
43 2 "b > 12 AND b < 16" {/*ANY(a) AND b>? AND b<?*/}
44 3 "b > 2 AND b < 16" {/*SCAN t1*/}
45 4 "b > 18 AND b < 25" {/*ANY(a) AND b>? AND b<?*/}
46 5 "b > 16" {/*ANY(a) AND b>?*/}
47 6 "b > 5" {/*SCAN t1*/}
48 7 "b < 15" {/*SCAN t1*/}
49 8 "b < 5" {/*ANY(a) AND b<?*/}
50 9 "5 > b" {/*ANY(a) AND b<?*/}
51 10 "b = '5'" {/*ANY(a) AND b=?*/}
52 11 "b > '12' AND b < '16'" {/*ANY(a) AND b>? AND b<?*/}
53 12 "b > '2' AND b < '16'" {/*SCAN t1*/}
54 13 "b > '18' AND b < '25'" {/*ANY(a) AND b>? AND b<?*/}
55 14 "b > '16'" {/*ANY(a) AND b>?*/}
56 15 "b > '5'" {/*SCAN t1*/}
57 16 "b < '15'" {/*SCAN t1*/}
58 17 "b < '5'" {/*ANY(a) AND b<?*/}
59 18 "'5' > b" {/*ANY(a) AND b<?*/}
86 CREATE TABLE t2(a TEXT, b TEXT, c TEXT COLLATE test_collate, d TEXT);
87 CREATE INDEX i2 ON t2(a, b, c);
91 set vocab(c) { a b c d e f g h i j k l m n o p q r s t }
92 set vocab(b) { one two three }
97 foreach var {a b c d} {
100 execsql { INSERT INTO t2 VALUES($a, $b, $c, $d) }
106 1 { c BETWEEN 'd' AND 'e' } {/*ANY(a) AND ANY(b) AND c>? AND c<?*/}
107 2 { c BETWEEN 'b' AND 'r' } {/*SCAN t2*/}
108 3 { c > 'q' } {/*ANY(a) AND ANY(b) AND c>?*/}
111 6 { c < 'b' } {/*ANY(a) AND ANY(b) AND c<?*/}
126 CREATE TABLE t3(a, b, c);
127 CREATE INDEX i3 ON t3(a, b);
171 1 "b BETWEEN -10000 AND -8000" {/*ANY(a) AND b>? AND b<?*/}
172 2 "b BETWEEN -10000 AND 'qqq'" {/*SCAN t3*/}
173 3 "b < X'5555'" {/*SCAN t3*/}
174 4 "b > X'5555'" {/*ANY(a) AND b>?*/}
175 5 "b > 'zzz'" {/*ANY(a) AND b>?*/}
176 6 "b < 'zzz'" {/*SCAN t3*/}