Lines Matching refs:rowid

70     SELECT rowid, * FROM t1;
85     SELECT rowid, * FROM t1;
99     SELECT rowid, * FROM t1;
173     SELECT * FROM t1 WHERE b=='y' AND rowid<0
178     SELECT * FROM t1 WHERE b=='y' AND rowid<0 AND rowid>=-20
188     SELECT * FROM t1 WHERE b>='y' AND rowid<10
200     SELECT rowid, * FROM t1;
205     SELECT rowid, * FROM t1 WHERE b<'second'
210     SELECT rowid, * FROM t1 WHERE 'second'>b
215     SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b
220     SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b AND 0<rowid
225     SELECT rowid, * FROM t1 WHERE b>'a'
230     DELETE FROM t1 WHERE rowid=4;
236     UPDATE t1 SET a=-4 WHERE rowid=8;
307     SELECT * FROM t1 WHERE 11=rowid
312     SELECT * FROM t1 WHERE 11=rowid AND b=='hello'
317     SELECT * FROM t1 WHERE 11=rowid AND b=='hello' AND c IS NOT NULL;
322     SELECT * FROM t1 WHERE rowid==11
338     SELECT * FROM t1 WHERE 8<rowid;
343     SELECT * FROM t1 WHERE 8<rowid AND 11>=oid;
367 # Make sure it is OK to insert a rowid of 0
379     SELECT rowid, a FROM t1
419     SELECT * FROM t1 WHERE rowid>=30;
424     SELECT * FROM t1 WHERE rowid>20;
434     SELECT rowid FROM t2;
446     SELECT rowid, a, c FROM t1 WHERE c=='www';