Lines Matching refs:test2
94 CREATE TABLE test2(
101 execsql {SELECT * from test2}
104 execsql {INSERT INTO test2(f1,f3) VALUES(+10,-10)}
105 execsql {SELECT * FROM test2}
108 execsql {INSERT INTO test2(f2,f4) VALUES(1.23,-3.45)}
109 execsql {SELECT * FROM test2 WHERE f1==-111}
112 execsql {INSERT INTO test2(f1,f2,f4) VALUES(77,+1.23,3.45)}
113 execsql {SELECT * FROM test2 WHERE f1==77}
117 DROP TABLE test2;
118 CREATE TABLE test2(
126 execsql {SELECT * from test2}
129 execsql {INSERT INTO test2(f2,f4) VALUES(-2.22,'hi!')}
130 execsql {SELECT * FROM test2}
133 execsql {INSERT INTO test2(f1,f5) VALUES(1,'xyzzy')}
134 execsql {SELECT * FROM test2 ORDER BY f1}
143 DELETE FROM test2;
144 CREATE INDEX index9 ON test2(f1,f2);
145 CREATE INDEX indext ON test2(f4,f5);
146 SELECT * from test2;
150 execsql {INSERT INTO test2(f2,f4) VALUES(-3.33,'hum')}
151 execsql {SELECT * FROM test2 WHERE f1=111 AND f2=-3.33}
154 execsql {INSERT INTO test2(f1,f2,f5) VALUES(22,-4.44,'wham')}
155 execsql {SELECT * FROM test2 WHERE f1=111 AND f2=-3.33}
158 execsql {SELECT * FROM test2 WHERE f1=22 AND f2=-4.44}