Lines Matching refs:t1
26 CREATE TABLE t1(a, b, c, UNIQUE(a,b));
28 SELECT c FROM t1 ORDER BY c;
36 # cmd An INSERT or REPLACE command to execute against table t1
38 # t1 Content of "c" column of t1 assuming no error in $cmd
41 foreach {i conf cmd t0 t1 t2} {
64 DELETE FROM t1;
66 INSERT INTO t1 VALUES(1,2,3);
69 $cmd INTO t1 VALUES(1,2,4);
72 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
75 } [list $t0 $t1 $t2]
82 DROP TABLE t1;
84 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(a,b));
86 SELECT c FROM t1 ORDER BY c;
94 # cmd An INSERT or REPLACE command to execute against table t1
96 # t1 Content of "c" column of t1 assuming no error in $cmd
99 foreach {i conf cmd t0 t1 t2} {
122 DELETE FROM t1;
124 INSERT INTO t1 VALUES(1,2,3);
127 $cmd INTO t1 VALUES(1,2,4);
130 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
133 } [list $t0 $t1 $t2]
140 DROP TABLE t1;
142 CREATE TABLE t1(a, b, c INTEGER, PRIMARY KEY(c), UNIQUE(a,b));
144 SELECT c FROM t1 ORDER BY c;
152 # cmd An INSERT or REPLACE command to execute against table t1
154 # t1 Content of "c" column of t1 assuming no error in $cmd
157 foreach {i conf cmd t0 t1 t2} {
180 DELETE FROM t1;
182 INSERT INTO t1 VALUES(1,2,3);
185 $cmd INTO t1 VALUES(1,2,4);
188 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
191 } [list $t0 $t1 $t2]
207 # cmd An INSERT or REPLACE command to execute against table t1
209 # t1 Content of "c" column of t1 assuming no error in $cmd
212 foreach {i conf1 conf2 cmd t0 t1 t2} {
238 DROP TABLE t1;
239 CREATE TABLE t1(a,b,c,UNIQUE(a,b) $conf1);
241 INSERT INTO t1 VALUES(1,2,3);
244 $cmd INTO t1 VALUES(1,2,4);
247 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
250 } [list $t0 $t1 $t2]
266 # cmd An INSERT or REPLACE command to execute against table t1
268 # t1 Content of "c" column of t1 assuming no error in $cmd
271 foreach {i conf1 conf2 cmd t0 t1 t2} {
296 if {$t0} {set t1 {t1.c may not be NULL}}
301 DROP TABLE t1;
302 CREATE TABLE t1(a,b,c NOT NULL $conf1 DEFAULT 5);
306 $cmd INTO t1 VALUES(1,2,NULL);
309 if {!$r0} {set r1 [execsql {SELECT c FROM t1}]}
312 } [list $t0 $t1 $t2]
334 # cmd An UPDATE command to execute against table t1
336 # t1 Content of "b" column of t1 assuming no error in $cmd
339 foreach {i conf1 conf2 cmd t0 t1 t2} {
367 if {$t0} {set t1 {column a is not unique}}
372 DROP TABLE t1;
373 CREATE TABLE t1(a,b,c, UNIQUE(a) $conf1);
374 INSERT INTO t1 SELECT * FROM t2;
378 $cmd t1 SET b=b*2;
379 $cmd t1 SET a=c+5;
382 if {!$r0} {set r1 [execsql {SELECT a FROM t1 ORDER BY b}]}
385 } [list $t0 $t1 $t2]
392 DROP TABLE t1;
395 CREATE TABLE t1(a unique, b);
398 execsql "INSERT into t1 values($i,[expr {$i+1}]);"
401 SELECT count(*), min(a), max(b) FROM t1;
407 UPDATE OR IGNORE t1 SET a=1000;
415 SELECT b FROM t1 WHERE a=1000;
420 SELECT count(*) FROM t1;
426 UPDATE OR REPLACE t1 SET a=1001;
434 SELECT b FROM t1 WHERE a=1001;
439 SELECT count(*) FROM t1;
451 DELETE FROM t1;
452 INSERT INTO t1 VALUES(1,2);
455 INSERT OR IGNORE INTO t1 VALUES(2,3);
463 INSERT OR IGNORE INTO t1 VALUES(2,4);
471 INSERT OR REPLACE INTO t1 VALUES(2,4);
479 INSERT OR IGNORE INTO t1 SELECT * FROM t1;
487 INSERT OR IGNORE INTO t1 SELECT a+2,b+2 FROM t1;
495 INSERT OR IGNORE INTO t1 SELECT a+3,b+3 FROM t1;
673 DELETE FROM t1;
675 INSERT INTO t1 VALUES(1,2);
676 INSERT INTO t1 VALUES(1,3);
679 execsql {SELECT * FROM t1}