Lines Matching refs:test2

96     CREATE TABLE test2(
103   execsql {SELECT * from test2}
106   execsql {INSERT INTO test2(f1,f3) VALUES(+10,-10)}
107   execsql {SELECT * FROM test2}
110   execsql {INSERT INTO test2(f2,f4) VALUES(1.23,-3.45)}
111   execsql {SELECT * FROM test2 WHERE f1==-111}
114   execsql {INSERT INTO test2(f1,f2,f4) VALUES(77,+1.23,3.45)}
115   execsql {SELECT * FROM test2 WHERE f1==77}
119     DROP TABLE test2;
120     CREATE TABLE test2(
128   execsql {SELECT * from test2}
131   execsql {INSERT INTO test2(f2,f4) VALUES(-2.22,'hi!')}
132   execsql {SELECT * FROM test2}
135   execsql {INSERT INTO test2(f1,f5) VALUES(1,'xyzzy')}
136   execsql {SELECT * FROM test2 ORDER BY f1}
145     DELETE FROM test2;
146     CREATE INDEX index9 ON test2(f1,f2);
147     CREATE INDEX indext ON test2(f4,f5);
148     SELECT * from test2;
152   execsql {INSERT INTO test2(f2,f4) VALUES(-3.33,'hum')}
153   execsql {SELECT * FROM test2 WHERE f1=111 AND f2=-3.33}
156   execsql {INSERT INTO test2(f1,f2,f5) VALUES(22,-4.44,'wham')}
157   execsql {SELECT * FROM test2 WHERE f1=111 AND f2=-3.33}
160   execsql {SELECT * FROM test2 WHERE f1=22 AND f2=-4.44}