Lines Matching refs:t3

735     CREATE TABLE t3 AS SELECT * FROM t2;
736     INSERT INTO t2 SELECT * FROM t3;
747     CREATE TEMP TABLE t3 AS SELECT * FROM t2;
748     INSERT INTO t2 SELECT * FROM t3;
759     CREATE TEMP TABLE t3 AS SELECT * FROM t2;
760     INSERT INTO t2 SELECT * FROM t3;
763     CREATE INDEX i3a ON t3(x);
795     CREATE TABLE t3 AS SELECT * FROM t2;
822     CREATE TABLE t3(x TEXT);
823     INSERT INTO t3 VALUES(randstr(10,400));
824     INSERT INTO t3 VALUES(randstr(10,400));
825     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
826     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
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;
835     SELECT count(*) FROM t3;
839 # The following procedure computes a "signature" for table "t3".  If
842 # This is used to test ROLLBACK.  We gather a signature for t3, then
843 # make lots of changes to t3, then rollback and take another signature.
847   return [db eval {SELECT count(*), md5sum(x) FROM t3}]
852 # t3 a little larger, and thus takes a little longer, so doing 40 tests
875        DELETE FROM t3 WHERE random()%10!=0;
876        INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
877        INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
885        DELETE FROM t3 WHERE random()%10!=0;
886        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;
896          INSERT INTO t3 SELECT randstr(10,400) FROM t3 WHERE random()%10==0;