Lines Matching refs:t2

27     CREATE TABLE t2(x);
39 #   t2     Content of "x" column of t2
41 foreach {i conf cmd t0 t1 t2} {
65       DELETE FROM t2;
68       INSERT INTO t2 VALUES(1);
73     set r2 [execsql {SELECT x FROM t2}]
75   } [list $t0 $t1 $t2]
83     DROP TABLE t2;
85     CREATE TABLE t2(x);
97 #   t2     Content of "x" column of t2
99 foreach {i conf cmd t0 t1 t2} {
123       DELETE FROM t2;
126       INSERT INTO t2 VALUES(1);
131     set r2 [execsql {SELECT x FROM t2}]
133   } [list $t0 $t1 $t2]
141     DROP TABLE t2;
143     CREATE TABLE t2(x);
155 #   t2     Content of "x" column of t2
157 foreach {i conf cmd t0 t1 t2} {
181       DELETE FROM t2;
184       INSERT INTO t2 VALUES(1);
189     set r2 [execsql {SELECT x FROM t2}]
191   } [list $t0 $t1 $t2]
196     DROP TABLE t2;
197     CREATE TABLE t2(x);
198     SELECT x FROM t2;
210 #   t2     Content of "x" column of t2
212 foreach {i conf1 conf2 cmd t0 t1 t2} {
240       DELETE FROM t2;
243       INSERT INTO t2 VALUES(1);
248     set r2 [execsql {SELECT x FROM t2}]
250   } [list $t0 $t1 $t2]
255     DROP TABLE t2;
256     CREATE TABLE t2(x);
257     SELECT x FROM t2;
269 #   t2     Content of "x" column of t2
271 foreach {i conf1 conf2 cmd t0 t1 t2} {
303       DELETE FROM t2;
305       INSERT INTO t2 VALUES(1);
310     set r2 [execsql {SELECT x FROM t2}]
312   } [list $t0 $t1 $t2]
317     DROP TABLE t2;
318     CREATE TABLE t2(a,b,c);
319     INSERT INTO t2 VALUES(1,2,1);
320     INSERT INTO t2 VALUES(2,3,2);
321     INSERT INTO t2 VALUES(3,4,1);
322     INSERT INTO t2 VALUES(4,5,4);
323     SELECT c FROM t2 ORDER BY b;
337 #   t2     Content of "x" column of t3
339 foreach {i conf1 conf2 cmd t0 t1 t2} {
374       INSERT INTO t1 SELECT * FROM t2;
385   } [list $t0 $t1 $t2]
393     DROP TABLE t2;
507     CREATE TABLE t2(
521     INSERT INTO t2 VALUES(1,1,1,1,1);
522     INSERT INTO t2 VALUES(2,2,2,2,2);
523     SELECT * FROM t2;
528     INSERT INTO t2 VALUES(1,3,3,3,3);
529     SELECT * FROM t2;
534     UPDATE t2 SET a=a+1 WHERE a=1;
535     SELECT * FROM t2;
540     INSERT INTO t2 VALUES(3,1,3,3,3);
541     SELECT * FROM t2;
546     UPDATE t2 SET b=b+1 WHERE b=1;
547     SELECT * FROM t2;
554     INSERT INTO t2 VALUES(3,1,3,3,3);
555     SELECT * FROM t2;
566     UPDATE t2 SET b=b+1 WHERE b=1;
567     SELECT * FROM t2;
576     INSERT INTO t2 VALUES(3,3,3,1,3);
577     SELECT * FROM t2;
582     UPDATE t2 SET d=d+1 WHERE d=1;
583     SELECT * FROM t2;
590     INSERT INTO t2 VALUES(3,3,3,1,3);
591     SELECT * FROM t2;
602     UPDATE t2 SET d=d+1 WHERE d=1;
603     SELECT * FROM t2;
612     INSERT INTO t2 VALUES(3,3,3,3,1);
613     SELECT * FROM t2;
618     UPDATE t2 SET e=e+1 WHERE e=1;
619     SELECT * FROM t2;
626     INSERT INTO t2 VALUES(3,3,3,3,1);
627     SELECT * FROM t2;
638     UPDATE t2 SET e=e+1 WHERE e=1;
639     SELECT * FROM t2;
648     INSERT INTO t2 VALUES(3,3,1,3,3);
649     SELECT * FROM t2;
654     UPDATE t2 SET c=c-1 WHERE c=2;
655     SELECT * FROM t2;
662     INSERT INTO t2 VALUES(3,3,1,3,3);
663     SELECT * FROM t2;