Lines Matching refs:t3
737 CREATE TABLE t3 AS SELECT * FROM t2;
738 INSERT INTO t2 SELECT * FROM t3;
749 CREATE TEMP TABLE t3 AS SELECT * FROM t2;
750 INSERT INTO t2 SELECT * FROM t3;
761 CREATE TEMP TABLE t3 AS SELECT * FROM t2;
762 INSERT INTO t2 SELECT * FROM t3;
765 CREATE INDEX i3a ON t3(x);
797 CREATE TABLE t3 AS SELECT * FROM t2;
824 CREATE TABLE t3(x TEXT);
825 INSERT INTO t3 VALUES(randstr(10,400));
826 INSERT INTO t3 VALUES(randstr(10,400));
827 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
828 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
829 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
830 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
831 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
832 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
833 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
834 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
835 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
837 SELECT count(*) FROM t3;
841 # The following procedure computes a "signature" for table "t3". If
844 # This is used to test ROLLBACK. We gather a signature for t3, then
845 # make lots of changes to t3, then rollback and take another signature.
849 return [db eval {SELECT count(*), md5sum(x) FROM t3}]
854 # t3 a little larger, and thus takes a little longer, so doing 40 tests
877 DELETE FROM t3 WHERE random()%10!=0;
878 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
879 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
887 DELETE FROM t3 WHERE random()%10!=0;
888 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
889 DELETE FROM t3 WHERE random()%10!=0;
890 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
898 INSERT INTO t3 SELECT randstr(10,400) FROM t3 WHERE random()%10==0;