Lines Matching refs:t1
33 CREATE TABLE t1(a, b);
34 INSERT INTO t1 VALUES(randomblob(10), randomblob(4000)); -- 1
35 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 2
36 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 4
37 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 8
38 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 16
39 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 32
40 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 64
41 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 128
42 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 256
43 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 512
44 SELECT count(*) FROM t1;
47 do_test multiplex-1.$tn.1 { sql1 { SELECT count(*) FROM t1 } } 512
48 do_test multiplex-1.$tn.2 { sql2 { SELECT count(*) FROM t1 } } 512
49 sql2 { DELETE FROM t1 ; VACUUM }
50 do_test multiplex-1.$tn.3 { sql1 { SELECT count(*) FROM t1 } } 0
53 INSERT INTO t1 VALUES(randomblob(10), randomblob(4000)); -- 1
54 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 2
55 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 4
56 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 8
57 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 16
58 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 32
59 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 64
60 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 128
61 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 256
62 INSERT INTO t1 SELECT randomblob(10), randomblob(4000) FROM t1; -- 512
63 SELECT count(*) FROM t1;
66 do_test multiplex-1.$tn.4 { sql2 { SELECT count(*) FROM t1 } } 512