Lines Matching refs:t3
35 CREATE TABLE t3(x TEXT);
36 INSERT INTO t3 VALUES(randstr(10,400));
37 INSERT INTO t3 VALUES(randstr(10,400));
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;
45 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
46 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
48 SELECT count(*) FROM t3;
52 # The following procedure computes a "signature" for table "t3". If
55 # This is used to test ROLLBACK. We gather a signature for t3, then
56 # make lots of changes to t3, then rollback and take another signature.
60 set rx [db eval {SELECT x FROM t3}]
67 # set r [db eval {SELECT count(*), md5sum(x) FROM t3}]
88 DELETE FROM t3 WHERE random()%10!=0;
89 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
90 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;
102 DELETE FROM t3 WHERE random()%10!=0;
103 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
111 INSERT INTO t3 SELECT randstr(10,400) FROM t3 WHERE random()%10==0;
136 } {t3 t4}
142 } {t3}
148 } {t3 t4}
209 DROP TABLE t3;
216 CREATE TABLE t3(x);
217 INSERT INTO t3 VALUES(1);
229 # t2 Content of "x" column of t3
267 UPDATE t3 SET x=0;
269 $cmd t3 SET x=1;
275 set r2 [execsql {SELECT x FROM t3}]
291 } {t1 t3 t4}
297 } {t1 t2 t3 t4}
331 } {t1 t2 t3 t4 t5}
337 } {t1 t2 t3 t4}