Lines Matching refs:t1
28 CREATE TABLE t1(a, b, c, UNIQUE(a,b));
30 SELECT c FROM t1 ORDER BY c;
38 # cmd An INSERT or REPLACE command to execute against table t1
40 # t1 Content of "c" column of t1 assuming no error in $cmd
43 foreach {i conf cmd t0 t1 t2} {
66 DELETE FROM t1;
68 INSERT INTO t1 VALUES(1,2,3);
71 $cmd INTO t1 VALUES(1,2,4);
74 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
77 } [list $t0 $t1 $t2]
84 DROP TABLE t1;
86 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(a,b));
88 SELECT c FROM t1 ORDER BY c;
96 # cmd An INSERT or REPLACE command to execute against table t1
98 # t1 Content of "c" column of t1 assuming no error in $cmd
101 foreach {i conf cmd t0 t1 t2} {
124 DELETE FROM t1;
126 INSERT INTO t1 VALUES(1,2,3);
129 $cmd INTO t1 VALUES(1,2,4);
132 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
135 } [list $t0 $t1 $t2]
142 DROP TABLE t1;
144 CREATE TABLE t1(a, b, c INTEGER, PRIMARY KEY(c), UNIQUE(a,b));
146 SELECT c FROM t1 ORDER BY c;
154 # cmd An INSERT or REPLACE command to execute against table t1
156 # t1 Content of "c" column of t1 assuming no error in $cmd
159 foreach {i conf cmd t0 t1 t2} {
182 DELETE FROM t1;
184 INSERT INTO t1 VALUES(1,2,3);
187 $cmd INTO t1 VALUES(1,2,4);
190 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
193 } [list $t0 $t1 $t2]
209 # cmd An INSERT or REPLACE command to execute against table t1
211 # t1 Content of "c" column of t1 assuming no error in $cmd
214 foreach {i conf1 conf2 cmd t0 t1 t2} {
240 DROP TABLE t1;
241 CREATE TABLE t1(a,b,c,UNIQUE(a,b) $conf1);
243 INSERT INTO t1 VALUES(1,2,3);
246 $cmd INTO t1 VALUES(1,2,4);
249 if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
252 } [list $t0 $t1 $t2]
268 # cmd An INSERT or REPLACE command to execute against table t1
270 # t1 Content of "c" column of t1 assuming no error in $cmd
273 foreach {i conf1 conf2 cmd t0 t1 t2} {
298 if {$t0} {set t1 {t1.c may not be NULL}}
303 DROP TABLE t1;
304 CREATE TABLE t1(a,b,c NOT NULL $conf1 DEFAULT 5);
308 $cmd INTO t1 VALUES(1,2,NULL);
311 if {!$r0} {set r1 [execsql {SELECT c FROM t1}]}
314 } [list $t0 $t1 $t2]
336 # cmd An UPDATE command to execute against table t1
338 # t1 Content of "b" column of t1 assuming no error in $cmd
341 foreach {i conf1 conf2 cmd t0 t1 t2} {
369 if {$t0} {set t1 {column a is not unique}}
374 DROP TABLE t1;
375 CREATE TABLE t1(a,b,c, UNIQUE(a) $conf1);
376 INSERT INTO t1 SELECT * FROM t2;
380 $cmd t1 SET b=b*2;
381 $cmd t1 SET a=c+5;
384 if {!$r0} {set r1 [execsql {SELECT a FROM t1 ORDER BY b}]}
387 } [list $t0 $t1 $t2]
394 DROP TABLE t1;
397 CREATE TABLE t1(a unique, b);
400 execsql "INSERT into t1 values($i,[expr {$i+1}]);"
403 SELECT count(*), min(a), max(b) FROM t1;
409 UPDATE OR IGNORE t1 SET a=1000;
417 SELECT b FROM t1 WHERE a=1000;
422 SELECT count(*) FROM t1;
428 UPDATE OR REPLACE t1 SET a=1001;
436 SELECT b FROM t1 WHERE a=1001;
441 SELECT count(*) FROM t1;
453 DELETE FROM t1;
454 INSERT INTO t1 VALUES(1,2);
457 INSERT OR IGNORE INTO t1 VALUES(2,3);
465 INSERT OR IGNORE INTO t1 VALUES(2,4);
473 INSERT OR REPLACE INTO t1 VALUES(2,4);
481 INSERT OR IGNORE INTO t1 SELECT * FROM t1;
489 INSERT OR IGNORE INTO t1 SELECT a+2,b+2 FROM t1;
497 INSERT OR IGNORE INTO t1 SELECT a+3,b+3 FROM t1;
675 DELETE FROM t1;
677 INSERT INTO t1 VALUES(1,2);
678 INSERT INTO t1 VALUES(1,3);
681 execsql {SELECT * FROM t1}