Lines Matching refs:t1
27 CREATE TABLE t1(x int, y int);
28 INSERT INTO t1 VALUES(1,2);
29 INSERT INTO t1 VALUES(3,4);
30 SELECT x FROM t1 ORDER BY y;
34 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
44 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
49 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
54 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
59 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
64 set sql "SELECT x FROM t1 WHERE _rowid_==$x2rowid(1)"
72 execsql "SELECT x FROM t1 WHERE rowid=$norow"
76 set v [execsql {SELECT x, oid FROM t1 order by x}]
82 set v [execsql {SELECT x, RowID FROM t1 order by x}]
88 set v [execsql {SELECT x, _rowid_ FROM t1 order by x}]
97 INSERT INTO t1(rowid,x,y) VALUES(1234,5,6);
98 SELECT rowid, * FROM t1;
103 UPDATE t1 SET rowid=12345 WHERE x==1;
104 SELECT rowid, * FROM t1
109 INSERT INTO t1(y,x,oid) VALUES(8,7,1235);
110 SELECT rowid, * FROM t1 WHERE rowid>1000;
115 UPDATE t1 SET oid=12346 WHERE x==1;
116 SELECT rowid, * FROM t1;
121 INSERT INTO t1(x,_rowid_,y) VALUES(9,1236,10);
122 SELECT rowid, * FROM t1 WHERE rowid>1000;
127 UPDATE t1 SET _rowid_=12347 WHERE x==1;
128 SELECT rowid, * FROM t1 WHERE rowid>1000;
137 set sql "UPDATE t1 SET x=2 WHERE OID==$x2rowid(3)"
139 execsql {SELECT x FROM t1 ORDER BY x}
143 set sql "UPDATE t1 SET x=3 WHERE _rowid_==$x2rowid(3)"
145 execsql {SELECT x FROM t1 ORDER BY x}
151 set v [catch {execsql {CREATE INDEX idxt1 ON t1(rowid)}} msg]
153 } {1 {table t1 has no column named rowid}}
155 set v [catch {execsql {CREATE INDEX idxt1 ON t1(_rowid_)}} msg]
157 } {1 {table t1 has no column named _rowid_}}
159 set v [catch {execsql {CREATE INDEX idxt1 ON t1(oid)}} msg]
161 } {1 {table t1 has no column named oid}}
163 set v [catch {execsql {CREATE INDEX idxt1 ON t1(x, rowid)}} msg]
165 } {1 {table t1 has no column named rowid}}
202 DELETE FROM t1;
206 execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])"
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}
236 execsql {CREATE INDEX idxt1 ON t1(x)}
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}
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
277 execsql {DELETE FROM t1 WHERE _rowid_ IN (SELECT oid FROM t1 WHERE x>8)}
278 execsql {SELECT max(x) FROM t1}
285 SELECT x FROM t1
290 if {[execsql "SELECT x FROM t1 WHERE rowid=$::norow"]==""} break
293 DELETE FROM t1 WHERE rowid=$::norow
298 SELECT x FROM t1
309 DELETE FROM t1;
312 INSERT INTO t1 VALUES(1,2);
313 SELECT rowid, * FROM t1;
318 INSERT INTO t1 VALUES(99,100);
319 SELECT rowid,* FROM t1