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
293 foreach {i conf1 cmd t0 t1 t2 t3 t4} {
331       INSERT INTO t1 SELECT * FROM t2;
342   } [list $t0 $t1 $t2 $t3]
350     DROP TABLE t2;
462     CREATE TABLE t2(
476     INSERT INTO t2 VALUES(1,1,1,1,1);
477     INSERT INTO t2 VALUES(2,2,2,2,2);
478     SELECT * FROM t2;
483     INSERT INTO t2 VALUES(1,3,3,3,3);
484     SELECT * FROM t2;
489     UPDATE t2 SET a=a+1 WHERE a=1;
490     SELECT * FROM t2;
495     INSERT INTO t2 VALUES(3,1,3,3,3);
497 } {1 {UNIQUE constraint failed: t2.b}}
499   db eval {SELECT * FROM t2;}
503     UPDATE t2 SET b=b+1 WHERE b=1;
504     SELECT * FROM t2;
506 } {1 {UNIQUE constraint failed: t2.b}}
508   db eval {SELECT * FROM t2;}
514     INSERT INTO t2 VALUES(3,1,3,3,3);
515     SELECT * FROM t2;
517 } {1 {UNIQUE constraint failed: t2.b}}
526     UPDATE t2 SET b=b+1 WHERE b=1;
527     SELECT * FROM t2;
529 } {1 {UNIQUE constraint failed: t2.b}}
536     INSERT INTO t2 VALUES(3,3,3,1,3);
537     SELECT * FROM t2;
539 } {1 {UNIQUE constraint failed: t2.d}}
542     UPDATE t2 SET d=d+1 WHERE d=1;
543     SELECT * FROM t2;
545 } {1 {UNIQUE constraint failed: t2.d}}
550     INSERT INTO t2 VALUES(3,3,3,1,3);
551     SELECT * FROM t2;
553 } {1 {UNIQUE constraint failed: t2.d}}
562     UPDATE t2 SET d=d+1 WHERE d=1;
563     SELECT * FROM t2;
565 } {1 {UNIQUE constraint failed: t2.d}}
572     INSERT INTO t2 VALUES(3,3,3,3,1);
573     SELECT * FROM t2;
575 } {1 {UNIQUE constraint failed: t2.e}}
578     UPDATE t2 SET e=e+1 WHERE e=1;
579     SELECT * FROM t2;
581 } {1 {UNIQUE constraint failed: t2.e}}
586     INSERT INTO t2 VALUES(3,3,3,3,1);
587     SELECT * FROM t2;
589 } {1 {UNIQUE constraint failed: t2.e}}
599     UPDATE t2 SET e=e+1 WHERE e=1;
600     SELECT * FROM t2;
602 } {1 {UNIQUE constraint failed: t2.e}}
610     INSERT INTO t2 VALUES(3,3,1,3,3);
611     SELECT * FROM t2;
616     UPDATE t2 SET c=c-1 WHERE c=2;
617     SELECT * FROM t2;
624     INSERT INTO t2 VALUES(3,3,1,3,3);
625     SELECT * FROM t2;