Lines Matching refs:test1

23   set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
25 } {1 {no such table: test1}}
37   execsql {CREATE TABLE test1(one int, two int, three int)}
38   set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
40 } {1 {table test1 has 3 columns but 2 values were supplied}}
42   set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
44 } {1 {table test1 has 3 columns but 4 values were supplied}}
46   set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg]
50   set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg]
57   set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg]
59 } {1 {table test1 has no column named four}}
64   execsql {INSERT INTO test1 VALUES(1,2,3)}
65   execsql {SELECT * FROM test1}
68   execsql {INSERT INTO test1 VALUES(4,5,6)}
69   execsql {SELECT * FROM test1 ORDER BY one}
72   execsql {INSERT INTO test1 VALUES(7,8,9)}
73   execsql {SELECT * FROM test1 ORDER BY one}
77   execsql {DELETE FROM test1}
78   execsql {INSERT INTO test1(one,two) VALUES(1,2)}
79   execsql {SELECT * FROM test1 ORDER BY one}
82   execsql {INSERT INTO test1(two,three) VALUES(5,6)}
83   execsql {SELECT * FROM test1 ORDER BY one}
86   execsql {INSERT INTO test1(three,one) VALUES(7,8)}
87   execsql {SELECT * FROM test1 ORDER BY one}
230   # Verify that table "test1" begins on page 3.  This should be the same
233     SELECT rootpage FROM sqlite_master WHERE name='test1';
245     INSERT INTO t4 SELECT one FROM test1 WHERE three=7;
250   # verify that no temporary table is used to copy test1 to t4
252     EXPLAIN INSERT INTO t4 SELECT one FROM test1;