Lines Matching refs:t2
37 --task 2 build-t2
38 DROP TABLE IF EXISTS t2;
39 CREATE TABLE t2(a INTEGER PRIMARY KEY, b);
41 INSERT INTO t2 VALUES(1, randomblob(2000));
42 INSERT INTO t2 VALUES(2, randomblob(1000));
44 INSERT INTO t2 SELECT a+2, randomblob(1500) FROM t2;
45 INSERT INTO t2 SELECT a+4, randomblob(1500) FROM t2;
46 INSERT INTO t2 SELECT a+8, randomblob(1500) FROM t2;
48 INSERT INTO t2 SELECT a+16, randomblob(1500) FROM t2;
50 INSERT INTO t2 SELECT a+32, randomblob(1500) FROM t2;
51 SELECT count(*) FROM t2;
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;
164 SELECT count(*), sum(length(b)) FROM t2;
174 SELECT t1.a FROM t1, t2
175 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
184 SELECT t1.a FROM t1, t2
185 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
194 SELECT t1.a FROM t1, t2
195 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
204 SELECT t1.a FROM t1, t2
205 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
214 SELECT t1.a FROM t1, t2
215 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
251 CREATE INDEX t2b ON t2(b DESC);
263 SELECT t1.a FROM t1, t2
264 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
273 SELECT t1.a FROM t1, t2
274 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
283 SELECT t1.a FROM t1, t2
284 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
293 SELECT t1.a FROM t1, t2
294 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
303 SELECT t1.a FROM t1, t2
304 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
326 UPDATE t2 SET b=randomblob(20000);
328 UPDATE t2 SET b='x'||a||'y';
329 SELECT a FROM t2 WHERE b='x63y';
356 SELECT t1.a FROM t1, t2
357 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
368 SELECT t1.a FROM t1, t2
369 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
380 SELECT t1.a FROM t1, t2
381 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
392 SELECT t1.a FROM t1, t2
393 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
404 SELECT t1.a FROM t1, t2
405 WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')