Lines Matching refs:test1

21   set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
23 } {1 {no such table: test1}}
35   execsql {CREATE TABLE test1(one int, two int, three int)}
36   set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
38 } {1 {table test1 has 3 columns but 2 values were supplied}}
40   set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
42 } {1 {table test1 has 3 columns but 4 values were supplied}}
44   set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg]
48   set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg]
55   set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg]
57 } {1 {table test1 has no column named four}}
62   execsql {INSERT INTO test1 VALUES(1,2,3)}
63   execsql {SELECT * FROM test1}
66   execsql {INSERT INTO test1 VALUES(4,5,6)}
67   execsql {SELECT * FROM test1 ORDER BY one}
70   execsql {INSERT INTO test1 VALUES(7,8,9)}
71   execsql {SELECT * FROM test1 ORDER BY one}
75   execsql {DELETE FROM test1}
76   execsql {INSERT INTO test1(one,two) VALUES(1,2)}
77   execsql {SELECT * FROM test1 ORDER BY one}
80   execsql {INSERT INTO test1(two,three) VALUES(5,6)}
81   execsql {SELECT * FROM test1 ORDER BY one}
84   execsql {INSERT INTO test1(three,one) VALUES(7,8)}
85   execsql {SELECT * FROM test1 ORDER BY one}
254     # Verify that table "test1" begins on page 3.  This should be the same
259       SELECT rootpage FROM sqlite_master WHERE name='test1';
273       INSERT INTO t4 SELECT one FROM test1 WHERE three=7;
279       # verify that no temporary table is used to copy test1 to t4
281         EXPLAIN INSERT INTO t4 SELECT one FROM test1;