Lines Matching refs:t1
33 CREATE TABLE t1(a,b,c);
36 INSERT INTO t1 VALUES(1,2,3);
37 INSERT INTO t1 VALUES(4,5,6);
39 SELECT * FROM t1;
41 INSERT INTO t1 VALUES(1,2,3);
42 INSERT INTO t1 VALUES(4,5,6);
44 SELECT * FROM t1;
45 DELETE FROM t1 WHERE a<100;
60 CREATE TABLE t1(a, b, c);
61 INSERT INTO t1 VALUES(1, randstr(50,50), randstr(50,50));
62 INSERT INTO t1 SELECT a+2, b||'-'||rowid, c||'-'||rowid FROM t1;
63 INSERT INTO t1 SELECT a+4, b||'-'||rowid, c||'-'||rowid FROM t1;
64 INSERT INTO t1 SELECT a+8, b||'-'||rowid, c||'-'||rowid FROM t1;
65 INSERT INTO t1 SELECT a+16, b||'-'||rowid, c||'-'||rowid FROM t1;
66 INSERT INTO t1 SELECT a+32, b||'-'||rowid, c||'-'||rowid FROM t1;
67 INSERT INTO t1 SELECT a+64, b||'-'||rowid, c||'-'||rowid FROM t1;
68 INSERT INTO t1 SELECT a+128, b||'-'||rowid, c||'-'||rowid FROM t1;
69 INSERT INTO t1 VALUES(1, randstr(600,600), randstr(600,600));
70 CREATE TABLE t2 AS SELECT * FROM t1;
71 CREATE TABLE t3 AS SELECT * FROM t1;
130 CREATE TABLE t1(a,b,c);
156 CREATE TABLE t1(a, b, c);
181 CREATE TABLE t1(a, b);
182 INSERT INTO t1 VALUES(1, 2);
184 INSERT INTO t1 VALUES(3, 4);
192 SELECT * FROM t1;
203 CREATE TABLE t1(a,b,c);
204 INSERT INTO t1 VALUES(randstr(200,200), randstr(1000,1000), 2);
209 SELECT c FROM t1;
217 CREATE TABLE t1(a,b,c);
218 INSERT INTO t1 VALUES(randstr(200,200), randstr(1000,1000), 2);
220 INSERT INTO t1 VALUES(randstr(200,200), randstr(1000,1000), 2);
234 SELECT a FROM t1;
243 CREATE TABLE t1(a PRIMARY KEY, b);
246 execsql {INSERT INTO t1 VALUES(:i, 'hello world');}
255 INSERT INTO t1 VALUES('abc', 123);
256 INSERT INTO t1 VALUES('def', 123);
257 INSERT INTO t1 VALUES('ghi', 123);
258 INSERT INTO t1 SELECT (a+500)%900, 'good string' FROM t1;
261 if {$msg != "UNIQUE constraint failed: t1.a"} {
282 CREATE TABLE t1(a, b, c);
283 INSERT INTO t1 VALUES(randstr(50,50), randstr(100,100), randstr(10,10));
284 INSERT INTO t1 SELECT randstr(50,50), randstr(9,9), randstr(90,90) FROM t1;
285 INSERT INTO t1 SELECT randstr(50,50), randstr(9,9), randstr(90,90) FROM t1;
286 INSERT INTO t1 SELECT randstr(50,50), randstr(9,9), randstr(90,90) FROM t1;
287 INSERT INTO t1 SELECT randstr(50,50), randstr(9,9), randstr(90,90) FROM t1;
288 INSERT INTO t1 SELECT randstr(50,50), randstr(9,9), randstr(90,90) FROM t1;
300 CREATE TABLE t1(x);
301 INSERT INTO t1 VALUES( randomblob(1 * (512-4)) );
302 INSERT INTO t1 VALUES( randomblob(110 * (512-4)) );
303 INSERT INTO t1 VALUES( randomblob(2 * (512-4)) );
304 INSERT INTO t1 VALUES( randomblob(110 * (512-4)) );
305 INSERT INTO t1 VALUES( randomblob(3 * (512-4)) );
306 DELETE FROM t1 WHERE rowid = 3;
308 DELETE FROM t1 WHERE rowid = 1;
325 # Create a test database. Page 2 is the root page of table t1. The only
326 # row inserted into t1 has an overflow page - page 3. Page 3 will be
330 db eval { CREATE TABLE t1(x) }
331 db eval { INSERT INTO t1 VALUES(randomblob(1100)); }
333 db eval { INSERT INTO t1 VALUES(randomblob(2000)); }
341 CREATE TABLE t1(x);
352 INSERT INTO t1 VALUES(randomblob(20));
353 INSERT INTO t1 SELECT x FROM t1;
354 INSERT INTO t1 SELECT x FROM t1;
355 INSERT INTO t1 SELECT x FROM t1;
356 INSERT INTO t1 SELECT x FROM t1;
357 INSERT INTO t1 SELECT x FROM t1;
358 INSERT INTO t1 SELECT x FROM t1; /* 64 entries in t1 */
359 INSERT INTO t1 SELECT x FROM t1 LIMIT 14; /* 78 entries in t1 */
371 INSERT INTO t1 VALUES(randomblob(2000));
376 CREATE TABLE t1(x);
388 -- This statement inserts a row into t1 with an overflow page at the
389 -- end of the file. A long way from its parent (the root of t1).
390 INSERT INTO t1 VALUES(randomblob(1500));
393 -- This transaction will cause the root-page of table t1 to divide
400 INSERT INTO t1 VALUES(randomblob(100));
401 INSERT INTO t1 VALUES(randomblob(100));
402 INSERT INTO t1 VALUES(randomblob(100));
403 INSERT INTO t1 VALUES(randomblob(100));
404 INSERT INTO t1 VALUES(randomblob(100));
405 INSERT INTO t1 VALUES(randomblob(100));
406 INSERT INTO t1 VALUES(randomblob(100));
407 INSERT INTO t1 VALUES(randomblob(100));
408 INSERT INTO t1 VALUES(randomblob(100));
409 INSERT INTO t1 VALUES(randomblob(100));
417 CREATE TABLE t1(a);
418 CREATE INDEX i1 ON t1(a);
423 db eval {INSERT INTO t1 VALUES($v)}
426 DELETE FROM t1 WHERE oid > 85;
432 DELETE FROM t1 WHERE oid = 83;
444 CREATE TABLE t1(x);
445 INSERT INTO t1 VALUES(zeroblob(900));
446 INSERT INTO t1 VALUES(zeroblob(900));
447 INSERT INTO t1 SELECT x FROM t1;
448 INSERT INTO t1 SELECT x FROM t1;
449 INSERT INTO t1 SELECT x FROM t1;
450 INSERT INTO t1 SELECT x FROM t1;
451 INSERT INTO t1 SELECT x FROM t1;
452 INSERT INTO t1 SELECT x FROM t1;
453 INSERT INTO t1 SELECT x FROM t1;
454 DELETE FROM t1 WHERE rowid>202;
459 DELETE FROM t1 WHERE rowid IN (10,11,12) ;