Lines Matching refs:t3
33 CREATE TABLE t3(x TEXT);
34 INSERT INTO t3 VALUES(randstr(10,400));
35 INSERT INTO t3 VALUES(randstr(10,400));
36 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
37 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
38 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
39 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
40 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
41 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
42 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
43 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
44 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
46 SELECT count(*) FROM t3;
50 # The following procedure computes a "signature" for table "t3". If
53 # This is used to test ROLLBACK. We gather a signature for t3, then
54 # make lots of changes to t3, then rollback and take another signature.
58 set rx [db eval {SELECT x FROM t3}]
65 # set r [db eval {SELECT count(*), md5sum(x) FROM t3}]
86 DELETE FROM t3 WHERE random()%10!=0;
87 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
88 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
98 DELETE FROM t3 WHERE random()%10!=0;
99 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
100 DELETE FROM t3 WHERE random()%10!=0;
101 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
109 INSERT INTO t3 SELECT randstr(10,400) FROM t3 WHERE random()%10==0;
134 } {t3 t4}
140 } {t3}
146 } {t3 t4}
207 DROP TABLE t3;
214 CREATE TABLE t3(x);
215 INSERT INTO t3 VALUES(1);
227 # t2 Content of "x" column of t3
265 UPDATE t3 SET x=0;
267 $cmd t3 SET x=1;
273 set r2 [execsql {SELECT x FROM t3}]
289 } {t1 t3 t4}
295 } {t1 t2 t3 t4}
329 } {t1 t2 t3 t4 t5}
335 } {t1 t2 t3 t4}