Lines Matching refs:t1
23 return [db eval {SELECT count(*), md5sum(x) FROM t1}]
34 CREATE TABLE t1(x TEXT);
35 INSERT INTO t1 VALUES(randstr(10,400));
36 INSERT INTO t1 VALUES(randstr(10,400));
37 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
38 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
39 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
40 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
41 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
42 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
43 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
44 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
45 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
47 SELECT count(*) FROM t1;
63 DELETE FROM t1 WHERE random()%2==0;
65 INSERT INTO t1 SELECT randstr(10,10)||x FROM t1;
67 UPDATE t1 SET x = randstr(10, 400) WHERE random()%10;
81 DELETE FROM t1 WHERE random()%10==0;
82 INSERT INTO t1 SELECT randstr(10,10)||x FROM t1 WHERE random()%9==0;
90 DROP TABLE IF EXISTS t1;
92 CREATE TABLE t1(x TEXT);
93 CREATE INDEX i1 ON t1(x);
94 INSERT INTO t1 VALUES(randstr(10,400));
95 INSERT INTO t1 VALUES(randstr(10,400));
96 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
97 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
98 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
99 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
100 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
101 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
102 INSERT INTO t1 SELECT randstr(10,400) FROM t1;
104 SELECT count(*) FROM t1;
118 INSERT INTO t1 SELECT * FROM t1 WHERE rowid<50;
120 INSERT INTO t1 SELECT * FROM t1 WHERE rowid<50;
122 DELETE FROM t1 WHERE (random()%10)==0;
124 DELETE FROM t1 WHERE (random()%10)==0;
126 DELETE FROM t1 WHERE (random()%10)==0;
130 UPDATE t1 SET x = substr(x||x, 12, 100000) WHERE (rowid%12)==0;
132 UPDATE t1 SET x = substr(x||x, 14, 100000) WHERE (rowid%14)==0;
134 UPDATE t1 SET x = substr(x||x, 13, 100000) WHERE (rowid%13)==0;
137 DELETE FROM t1 WHERE rowid > (
138 SELECT rowid FROM t1 ORDER BY rowid ASC LIMIT 1 OFFSET 256
163 DELETE FROM t1 WHERE random()%10==0;
164 INSERT INTO t1 SELECT randstr(10,10)||x FROM t1 WHERE random()%9==0;