Lines Matching full:t2
170 CREATE TABLE t2(rowid int, x int, y int);
171 INSERT INTO t2 VALUES(0,2,3);
172 INSERT INTO t2 VALUES(4,5,6);
173 INSERT INTO t2 VALUES(7,8,9);
174 SELECT * FROM t2 ORDER BY x;
178 execsql {SELECT * FROM t2 ORDER BY rowid}
181 execsql {SELECT rowid, x, y FROM t2 ORDER BY rowid}
184 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
186 set r2 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY x DESC}]
191 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
201 DELETE FROM t2;
206 execsql {INSERT INTO t2 SELECT _rowid_, x*y, y*y FROM t1}
207 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
210 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
213 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.oid==t2.rowid}
216 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
219 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t2.rowid==t1.rowid}
222 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND t1.x==4}
225 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
228 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t2.rowid==t1.rowid}
231 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND t1.x==4}
235 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
238 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
241 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND 4==t1.x}
244 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
247 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
250 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND 4==t1.x}
253 execsql {CREATE INDEX idxt2 ON t2(y)}
256 SELECT t1.x FROM t2, t1
257 WHERE t2.y==256 AND t1.rowid==t2.rowid
263 SELECT t1.x FROM t2, t1
264 WHERE t1.OID==t2.rowid AND t2.y==81
269 SELECT t1.x FROM t1, t2
270 WHERE t2.y==256 AND t1.rowid==t2.rowid
308 DROP TABLE t2;
322 CREATE TABLE t2(a INTEGER PRIMARY KEY, b);
323 INSERT INTO t2(b) VALUES(55);
324 SELECT * FROM t2;
329 INSERT INTO t2(b) VALUES(66);
330 SELECT * FROM t2;
335 INSERT INTO t2(a,b) VALUES(1000000,77);
336 INSERT INTO t2(b) VALUES(88);
337 SELECT * FROM t2;
342 INSERT INTO t2(a,b) VALUES(2147483647,99);
343 INSERT INTO t2(b) VALUES(11);
344 SELECT b FROM t2 ORDER BY b;
349 SELECT b FROM t2 WHERE a NOT IN(1,2,1000000,1000001,2147483647);
354 INSERT INTO t2(b) VALUES(22);
355 INSERT INTO t2(b) VALUES(33);
356 INSERT INTO t2(b) VALUES(44);
357 INSERT INTO t2(b) VALUES(55);
358 SELECT b FROM t2 WHERE a NOT IN(1,2,1000000,1000001,2147483647) ORDER BY b;
363 DELETE FROM t2 WHERE a!=2;
364 INSERT INTO t2(b) VALUES(111);
365 SELECT * FROM t2;