Lines Matching refs:b
7 CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
21 SELECT avg(length(b)) FROM t1;
24 UPDATE t1 SET b='x'||a||'y';
25 SELECT sum(length(b)) FROM t1;
27 SELECT a FROM t1 WHERE b='x17y';
29 CREATE INDEX t1b ON t1(b);
30 SELECT a FROM t1 WHERE b='x17y';
32 SELECT a FROM t1 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
39 CREATE TABLE t2(a INTEGER PRIMARY KEY, b);
53 SELECT avg(length(b)) FROM t2;
56 UPDATE t2 SET b='x'||a||'y';
57 SELECT sum(length(b)) FROM t2;
59 SELECT a FROM t2 WHERE b='x17y';
61 CREATE INDEX t2b ON t2(b);
62 SELECT a FROM t2 WHERE b='x17y';
64 SELECT a FROM t2 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
70 CREATE TABLE t3(a INTEGER PRIMARY KEY, b);
84 SELECT avg(length(b)) FROM t3;
87 UPDATE t3 SET b='x'||a||'y';
88 SELECT sum(length(b)) FROM t3;
90 SELECT a FROM t3 WHERE b='x17y';
92 CREATE INDEX t3b ON t3(b);
93 SELECT a FROM t3 WHERE b='x17y';
95 SELECT a FROM t3 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
101 CREATE TABLE t4(a INTEGER PRIMARY KEY, b);
115 SELECT avg(length(b)) FROM t4;
118 UPDATE t4 SET b='x'||a||'y';
119 SELECT sum(length(b)) FROM t4;
121 SELECT a FROM t4 WHERE b='x17y';
123 CREATE INDEX t4b ON t4(b);
124 SELECT a FROM t4 WHERE b='x17y';
126 SELECT a FROM t4 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
132 CREATE TABLE t5(a INTEGER PRIMARY KEY, b);
146 SELECT avg(length(b)) FROM t5;
149 UPDATE t5 SET b='x'||a||'y';
150 SELECT sum(length(b)) FROM t5;
152 SELECT a FROM t5 WHERE b='x17y';
154 CREATE INDEX t5b ON t5(b);
155 SELECT a FROM t5 WHERE b='x17y';
157 SELECT a FROM t5 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
162 SELECT count(*), sum(length(b)) FROM t1;
164 SELECT count(*), sum(length(b)) FROM t2;
166 SELECT count(*), sum(length(b)) FROM t3;
168 SELECT count(*), sum(length(b)) FROM t4;
170 SELECT count(*), sum(length(b)) FROM t5;
175 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
179 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
185 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
189 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
195 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
199 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
205 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
209 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
215 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
219 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
230 CREATE INDEX t5b ON t5(b DESC);
237 CREATE INDEX t3b ON t3(b DESC);
244 CREATE INDEX t1b ON t1(b DESC);
251 CREATE INDEX t2b ON t2(b DESC);
258 CREATE INDEX t4b ON t4(b DESC);
264 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
268 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
274 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
278 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
284 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
288 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
294 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
298 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
304 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
308 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
319 UPDATE t1 SET b=randomblob(20000);
321 UPDATE t1 SET b='x'||a||'y';
322 SELECT a FROM t1 WHERE b='x63y';
326 UPDATE t2 SET b=randomblob(20000);
328 UPDATE t2 SET b='x'||a||'y';
329 SELECT a FROM t2 WHERE b='x63y';
333 UPDATE t3 SET b=randomblob(20000);
335 UPDATE t3 SET b='x'||a||'y';
336 SELECT a FROM t3 WHERE b='x63y';
340 UPDATE t4 SET b=randomblob(20000);
342 UPDATE t4 SET b='x'||a||'y';
343 SELECT a FROM t4 WHERE b='x63y';
347 UPDATE t5 SET b=randomblob(20000);
349 UPDATE t5 SET b='x'||a||'y';
350 SELECT a FROM t5 WHERE b='x63y';
357 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
361 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
369 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
373 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
381 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
385 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
393 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
397 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
405 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
409 WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')