Lines Matching refs:t2
172 CREATE TABLE t2(rowid int, x int, y int);
173 INSERT INTO t2 VALUES(0,2,3);
174 INSERT INTO t2 VALUES(4,5,6);
175 INSERT INTO t2 VALUES(7,8,9);
176 SELECT * FROM t2 ORDER BY x;
180 execsql {SELECT * FROM t2 ORDER BY rowid}
183 execsql {SELECT rowid, x, y FROM t2 ORDER BY rowid}
186 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
188 set r2 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY x DESC}]
193 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
203 DELETE FROM t2;
208 execsql {INSERT INTO t2 SELECT _rowid_, x*y, y*y FROM t1}
209 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
212 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
215 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.oid==t2.rowid}
218 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
221 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t2.rowid==t1.rowid}
224 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND t1.x==4}
227 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
230 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t2.rowid==t1.rowid}
233 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND t1.x==4}
237 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
240 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
243 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND 4==t1.x}
246 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
249 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
252 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND 4==t1.x}
255 execsql {CREATE INDEX idxt2 ON t2(y)}
258 SELECT t1.x FROM t2, t1
259 WHERE t2.y==256 AND t1.rowid==t2.rowid
265 SELECT t1.x FROM t2, t1
266 WHERE t1.OID==t2.rowid AND t2.y==81
271 SELECT t1.x FROM t1, t2
272 WHERE t2.y==256 AND t1.rowid==t2.rowid
310 DROP TABLE t2;
324 CREATE TABLE t2(a INTEGER PRIMARY KEY, b);
325 INSERT INTO t2(b) VALUES(55);
326 SELECT * FROM t2;
331 INSERT INTO t2(b) VALUES(66);
332 SELECT * FROM t2;
337 INSERT INTO t2(a,b) VALUES(1000000,77);
338 INSERT INTO t2(b) VALUES(88);
339 SELECT * FROM t2;
344 INSERT INTO t2(a,b) VALUES(2147483647,99);
345 INSERT INTO t2(b) VALUES(11);
346 SELECT b FROM t2 ORDER BY b;
351 SELECT b FROM t2 WHERE a NOT IN(1,2,1000000,1000001,2147483647);
356 INSERT INTO t2(b) VALUES(22);
357 INSERT INTO t2(b) VALUES(33);
358 INSERT INTO t2(b) VALUES(44);
359 INSERT INTO t2(b) VALUES(55);
360 SELECT b FROM t2 WHERE a NOT IN(1,2,1000000,1000001,2147483647) ORDER BY b;
365 DELETE FROM t2 WHERE a!=2;
366 INSERT INTO t2(b) VALUES(111);
367 SELECT * FROM t2;