Lines Matching refs:test1

25   set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
27 } {1 {no such table: test1}}
39   execsql {CREATE TABLE test1(one int, two int, three int)}
40   set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
42 } {1 {table test1 has 3 columns but 2 values were supplied}}
44   set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
46 } {1 {table test1 has 3 columns but 4 values were supplied}}
48   set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg]
52   set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg]
59   set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg]
61 } {1 {table test1 has no column named four}}
66   execsql {INSERT INTO test1 VALUES(1,2,3)}
67   execsql {SELECT * FROM test1}
70   execsql {INSERT INTO test1 VALUES(4,5,6)}
71   execsql {SELECT * FROM test1 ORDER BY one}
74   execsql {INSERT INTO test1 VALUES(7,8,9)}
75   execsql {SELECT * FROM test1 ORDER BY one}
79   execsql {DELETE FROM test1}
80   execsql {INSERT INTO test1(one,two) VALUES(1,2)}
81   execsql {SELECT * FROM test1 ORDER BY one}
84   execsql {INSERT INTO test1(two,three) VALUES(5,6)}
85   execsql {SELECT * FROM test1 ORDER BY one}
88   execsql {INSERT INTO test1(three,one) VALUES(7,8)}
89   execsql {SELECT * FROM test1 ORDER BY one}
232   # Verify that table "test1" begins on page 3.  This should be the same
235     SELECT rootpage FROM sqlite_master WHERE name='test1';
247     INSERT INTO t4 SELECT one FROM test1 WHERE three=7;
252   # verify that no temporary table is used to copy test1 to t4
254     EXPLAIN INSERT INTO t4 SELECT one FROM test1;