Lines Matching refs:t2

30     CREATE TABLE t2(x);
41 #   t2     Content of "x" column of t2
44 foreach {i cmd t0 t1 t2 t3} {
57       DELETE FROM t2;
60       INSERT INTO t2 VALUES(1); 
65     set r2 [execsql {SELECT x FROM t2}]
68   } [list $t0 $t1 $t2 $t3]
76     DROP TABLE t2;
78     CREATE TABLE t2(x);
89 #   t2     Content of "x" column of t2
91 foreach {i cmd t0 t1 t2} {
103       DELETE FROM t2;
106       INSERT INTO t2 VALUES(1); 
111     set r2 [execsql {SELECT x FROM t2}]
113   } [list $t0 $t1 $t2]
121     DROP TABLE t2;
123     CREATE TABLE t2(x);
134 #   t2     Content of "x" column of t2
136 foreach {i cmd t0 t1 t2} {
148       DELETE FROM t2;
151       INSERT INTO t2 VALUES(1); 
156     set r2 [execsql {SELECT x FROM t2}]
158   } [list $t0 $t1 $t2]
163     DROP TABLE t2;
164     CREATE TABLE t2(x);
165     SELECT x FROM t2;
176 #   t2     Content of "x" column of t2
178 foreach {i conf1 cmd t0 t1 t2} {
196       DELETE FROM t2;
199       INSERT INTO t2 VALUES(1); 
204     set r2 [execsql {SELECT x FROM t2}]
206   } [list $t0 $t1 $t2]
211     DROP TABLE t2;
212     CREATE TABLE t2(x);
213     SELECT x FROM t2;
224 #   t2     Content of "x" column of t2
226 foreach {i conf1 cmd t0 t1 t2} {
250       DELETE FROM t2;
252       INSERT INTO t2 VALUES(1); 
257     set r2 [execsql {SELECT x FROM t2}]
259   } [list $t0 $t1 $t2]
264     DROP TABLE t2;
265     CREATE TABLE t2(a,b,c);
266     INSERT INTO t2 VALUES(1,2,1);
267     INSERT INTO t2 VALUES(2,3,2);
268     INSERT INTO t2 VALUES(3,4,1);
269     INSERT INTO t2 VALUES(4,5,4);
270     SELECT c FROM t2 ORDER BY b;
283 #   t2     Content of "x" column of t3
292 foreach {i conf1 cmd t0 t1 t2 t3 t4} {
325       INSERT INTO t1 SELECT * FROM t2;
336   } [list $t0 $t1 $t2 $t3]
344     DROP TABLE t2;
461     CREATE TABLE t2(
475     INSERT INTO t2 VALUES(1,1,1,1,1);
476     INSERT INTO t2 VALUES(2,2,2,2,2);
477     SELECT * FROM t2;
482     INSERT INTO t2 VALUES(1,3,3,3,3);
483     SELECT * FROM t2;
488     UPDATE t2 SET a=a+1 WHERE a=1;
489     SELECT * FROM t2;
494     INSERT INTO t2 VALUES(3,1,3,3,3);
495     SELECT * FROM t2;
497 } {1 {UNIQUE constraint failed: t2.b}}
500     UPDATE t2 SET b=b+1 WHERE b=1;
501     SELECT * FROM t2;
503 } {1 {UNIQUE constraint failed: t2.b}}
508     INSERT INTO t2 VALUES(3,1,3,3,3);
509     SELECT * FROM t2;
511 } {1 {UNIQUE constraint failed: t2.b}}
520     UPDATE t2 SET b=b+1 WHERE b=1;
521     SELECT * FROM t2;
523 } {1 {UNIQUE constraint failed: t2.b}}
530     INSERT INTO t2 VALUES(3,3,3,1,3);
531     SELECT * FROM t2;
533 } {1 {UNIQUE constraint failed: t2.d}}
536     UPDATE t2 SET d=d+1 WHERE d=1;
537     SELECT * FROM t2;
539 } {1 {UNIQUE constraint failed: t2.d}}
544     INSERT INTO t2 VALUES(3,3,3,1,3);
545     SELECT * FROM t2;
547 } {1 {UNIQUE constraint failed: t2.d}}
556     UPDATE t2 SET d=d+1 WHERE d=1;
557     SELECT * FROM t2;
559 } {1 {UNIQUE constraint failed: t2.d}}
566     INSERT INTO t2 VALUES(3,3,3,3,1);
567     SELECT * FROM t2;
569 } {1 {UNIQUE constraint failed: t2.e}}
572     UPDATE t2 SET e=e+1 WHERE e=1;
573     SELECT * FROM t2;
575 } {1 {UNIQUE constraint failed: t2.e}}
580     INSERT INTO t2 VALUES(3,3,3,3,1);
581     SELECT * FROM t2;
583 } {1 {UNIQUE constraint failed: t2.e}}
593     UPDATE t2 SET e=e+1 WHERE e=1;
594     SELECT * FROM t2;
596 } {1 {UNIQUE constraint failed: t2.e}}
604     INSERT INTO t2 VALUES(3,3,1,3,3);
605     SELECT * FROM t2;
610     UPDATE t2 SET c=c-1 WHERE c=2;
611     SELECT * FROM t2;
618     INSERT INTO t2 VALUES(3,3,1,3,3);
619     SELECT * FROM t2;