Lines Matching refs:t2
29 CREATE TABLE t2(x);
41 # t2 Content of "x" column of t2
43 foreach {i conf cmd t0 t1 t2} {
67 DELETE FROM t2;
70 INSERT INTO t2 VALUES(1);
75 set r2 [execsql {SELECT x FROM t2}]
77 } [list $t0 $t1 $t2]
85 DROP TABLE t2;
87 CREATE TABLE t2(x);
99 # t2 Content of "x" column of t2
101 foreach {i conf cmd t0 t1 t2} {
125 DELETE FROM t2;
128 INSERT INTO t2 VALUES(1);
133 set r2 [execsql {SELECT x FROM t2}]
135 } [list $t0 $t1 $t2]
143 DROP TABLE t2;
145 CREATE TABLE t2(x);
157 # t2 Content of "x" column of t2
159 foreach {i conf cmd t0 t1 t2} {
183 DELETE FROM t2;
186 INSERT INTO t2 VALUES(1);
191 set r2 [execsql {SELECT x FROM t2}]
193 } [list $t0 $t1 $t2]
198 DROP TABLE t2;
199 CREATE TABLE t2(x);
200 SELECT x FROM t2;
212 # t2 Content of "x" column of t2
214 foreach {i conf1 conf2 cmd t0 t1 t2} {
242 DELETE FROM t2;
245 INSERT INTO t2 VALUES(1);
250 set r2 [execsql {SELECT x FROM t2}]
252 } [list $t0 $t1 $t2]
257 DROP TABLE t2;
258 CREATE TABLE t2(x);
259 SELECT x FROM t2;
271 # t2 Content of "x" column of t2
273 foreach {i conf1 conf2 cmd t0 t1 t2} {
305 DELETE FROM t2;
307 INSERT INTO t2 VALUES(1);
312 set r2 [execsql {SELECT x FROM t2}]
314 } [list $t0 $t1 $t2]
319 DROP TABLE t2;
320 CREATE TABLE t2(a,b,c);
321 INSERT INTO t2 VALUES(1,2,1);
322 INSERT INTO t2 VALUES(2,3,2);
323 INSERT INTO t2 VALUES(3,4,1);
324 INSERT INTO t2 VALUES(4,5,4);
325 SELECT c FROM t2 ORDER BY b;
339 # t2 Content of "x" column of t3
341 foreach {i conf1 conf2 cmd t0 t1 t2} {
376 INSERT INTO t1 SELECT * FROM t2;
387 } [list $t0 $t1 $t2]
395 DROP TABLE t2;
509 CREATE TABLE t2(
523 INSERT INTO t2 VALUES(1,1,1,1,1);
524 INSERT INTO t2 VALUES(2,2,2,2,2);
525 SELECT * FROM t2;
530 INSERT INTO t2 VALUES(1,3,3,3,3);
531 SELECT * FROM t2;
536 UPDATE t2 SET a=a+1 WHERE a=1;
537 SELECT * FROM t2;
542 INSERT INTO t2 VALUES(3,1,3,3,3);
543 SELECT * FROM t2;
548 UPDATE t2 SET b=b+1 WHERE b=1;
549 SELECT * FROM t2;
556 INSERT INTO t2 VALUES(3,1,3,3,3);
557 SELECT * FROM t2;
568 UPDATE t2 SET b=b+1 WHERE b=1;
569 SELECT * FROM t2;
578 INSERT INTO t2 VALUES(3,3,3,1,3);
579 SELECT * FROM t2;
584 UPDATE t2 SET d=d+1 WHERE d=1;
585 SELECT * FROM t2;
592 INSERT INTO t2 VALUES(3,3,3,1,3);
593 SELECT * FROM t2;
604 UPDATE t2 SET d=d+1 WHERE d=1;
605 SELECT * FROM t2;
614 INSERT INTO t2 VALUES(3,3,3,3,1);
615 SELECT * FROM t2;
620 UPDATE t2 SET e=e+1 WHERE e=1;
621 SELECT * FROM t2;
628 INSERT INTO t2 VALUES(3,3,3,3,1);
629 SELECT * FROM t2;
640 UPDATE t2 SET e=e+1 WHERE e=1;
641 SELECT * FROM t2;
650 INSERT INTO t2 VALUES(3,3,1,3,3);
651 SELECT * FROM t2;
656 UPDATE t2 SET c=c-1 WHERE c=2;
657 SELECT * FROM t2;
664 INSERT INTO t2 VALUES(3,3,1,3,3);
665 SELECT * FROM t2;