Lines Matching refs:t1
25 CREATE TABLE t1(x int, y int);
26 INSERT INTO t1 VALUES(1,2);
27 INSERT INTO t1 VALUES(3,4);
28 SELECT x FROM t1 ORDER BY y;
32 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
42 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
47 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
52 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
57 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
62 set sql "SELECT x FROM t1 WHERE _rowid_==$x2rowid(1)"
70 execsql "SELECT x FROM t1 WHERE rowid=$norow"
74 set v [execsql {SELECT x, oid FROM t1 order by x}]
80 set v [execsql {SELECT x, RowID FROM t1 order by x}]
86 set v [execsql {SELECT x, _rowid_ FROM t1 order by x}]
95 INSERT INTO t1(rowid,x,y) VALUES(1234,5,6);
96 SELECT rowid, * FROM t1;
101 UPDATE t1 SET rowid=12345 WHERE x==1;
102 SELECT rowid, * FROM t1
107 INSERT INTO t1(y,x,oid) VALUES(8,7,1235);
108 SELECT rowid, * FROM t1 WHERE rowid>1000;
113 UPDATE t1 SET oid=12346 WHERE x==1;
114 SELECT rowid, * FROM t1;
119 INSERT INTO t1(x,_rowid_,y) VALUES(9,1236,10);
120 SELECT rowid, * FROM t1 WHERE rowid>1000;
125 UPDATE t1 SET _rowid_=12347 WHERE x==1;
126 SELECT rowid, * FROM t1 WHERE rowid>1000;
135 set sql "UPDATE t1 SET x=2 WHERE OID==$x2rowid(3)"
137 execsql {SELECT x FROM t1 ORDER BY x}
141 set sql "UPDATE t1 SET x=3 WHERE _rowid_==$x2rowid(3)"
143 execsql {SELECT x FROM t1 ORDER BY x}
149 set v [catch {execsql {CREATE INDEX idxt1 ON t1(rowid)}} msg]
151 } {1 {table t1 has no column named rowid}}
153 set v [catch {execsql {CREATE INDEX idxt1 ON t1(_rowid_)}} msg]
155 } {1 {table t1 has no column named _rowid_}}
157 set v [catch {execsql {CREATE INDEX idxt1 ON t1(oid)}} msg]
159 } {1 {table t1 has no column named oid}}
161 set v [catch {execsql {CREATE INDEX idxt1 ON t1(x, rowid)}} msg]
163 } {1 {table t1 has no column named rowid}}
200 DELETE FROM t1;
204 execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])"
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}
234 execsql {CREATE INDEX idxt1 ON t1(x)}
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}
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
275 execsql {DELETE FROM t1 WHERE _rowid_ IN (SELECT oid FROM t1 WHERE x>8)}
276 execsql {SELECT max(x) FROM t1}
283 SELECT x FROM t1
288 if {[execsql "SELECT x FROM t1 WHERE rowid=$::norow"]==""} break
291 DELETE FROM t1 WHERE rowid=$::norow
296 SELECT x FROM t1
307 DELETE FROM t1;
310 INSERT INTO t1 VALUES(1,2);
311 SELECT rowid, * FROM t1;
316 INSERT INTO t1 VALUES(99,100);
317 SELECT rowid,* FROM t1