Lines Matching refs:rowid
62 SELECT * FROM uuu WHERE rowid = 3;
63 SELECT * FROM uuu WHERE rowid = 11;
67 SELECT * FROM uuu WHERE rowid IN (12, 10, 2);
71 SELECT * FROM uuu WHERE rowid BETWEEN 3 AND 11;
75 SELECT * FROM uuu WHERE rowid BETWEEN 11 AND 15;
79 SELECT * FROM uuu WHERE rowid BETWEEN -46 AND 1500;
103 SELECT * FROM qll WHERE rowid BETWEEN 10 AND 21;
114 # 2.3.*: Non rowid tables.
130 } {1 {no such rowid table: t555}}
133 } {1 {no such rowid table: aux.t555}}
136 } {1 {no such rowid table: xua.t555}}
148 } {1 {no such rowid table: main.wr1}}
151 } {1 {no such rowid table: v1}}
154 } {1 {no such rowid table: v2}}
157 } {1 {no such rowid table: wr2}}
160 } {1 {no such rowid table: wr3}}
210 " {1 {rowid range mismatch error}}
241 SELECT * FROM uu WHERE rowid = 10;
244 SELECT * FROM uu WHERE rowid = 25;
247 do_execsql_test 3.3 { SELECT count(*) FROM uu WHERE rowid <= 24 } {24}
251 # the range specified. For example, (rowid <= 25) matches 100 rows. This
252 # is because the module implements (rowid <= 25) as a full table scan
254 do_execsql_test 3.4.1 { SELECT count(*) FROM uu WHERE rowid <= 25 } {100}
255 do_execsql_test 3.4.2 { SELECT count(*) FROM uu WHERE rowid <= 26 } {126}
256 do_execsql_test 3.4.3 { SELECT count(*) FROM uu WHERE rowid <= 73 } {173}
257 do_execsql_test 3.4.4 { SELECT count(*) FROM uu WHERE rowid <= 74 } {200}
258 do_execsql_test 3.4.5 { SELECT count(*) FROM uu WHERE rowid <= 75 } {275}
259 do_execsql_test 3.4.6 { SELECT count(*) FROM uu WHERE rowid <= 99 } {299}
260 do_execsql_test 3.4.7 { SELECT count(*) FROM uu WHERE rowid <= 100 } {300}
261 do_execsql_test 3.4.8 { SELECT count(*) FROM uu WHERE rowid <= 101 } {300}
263 do_execsql_test 3.5.1 { SELECT count(*) FROM uu WHERE rowid < 25 } {24}
264 do_execsql_test 3.5.2 { SELECT count(*) FROM uu WHERE rowid < 26 } {100}
265 do_execsql_test 3.5.3 { SELECT count(*) FROM uu WHERE rowid < 27 } {126}
266 do_execsql_test 3.5.4 { SELECT count(*) FROM uu WHERE rowid < 73 } {172}
267 do_execsql_test 3.5.5 { SELECT count(*) FROM uu WHERE rowid < 74 } {173}
268 do_execsql_test 3.5.6 { SELECT count(*) FROM uu WHERE rowid < 75 } {200}
269 do_execsql_test 3.5.7 { SELECT count(*) FROM uu WHERE rowid < 76 } {275}
270 do_execsql_test 3.5.8 { SELECT count(*) FROM uu WHERE rowid < 99 } {298}
271 do_execsql_test 3.5.9 { SELECT count(*) FROM uu WHERE rowid < 100 } {299}
272 do_execsql_test 3.5.10 { SELECT count(*) FROM uu WHERE rowid < 101 } {300}
274 do_execsql_test 3.6.1 { SELECT count(*) FROM uu WHERE rowid > 24 } {276}
275 do_execsql_test 3.6.1 { SELECT count(*) FROM uu WHERE rowid > 25 } {200}
276 do_execsql_test 3.6.2 { SELECT count(*) FROM uu WHERE rowid > 26 } {174}
277 do_execsql_test 3.6.3 { SELECT count(*) FROM uu WHERE rowid > 27 } {173}
278 do_execsql_test 3.6.4 { SELECT count(*) FROM uu WHERE rowid > 73 } {127}
279 do_execsql_test 3.6.5 { SELECT count(*) FROM uu WHERE rowid > 74 } {100}
280 do_execsql_test 3.6.6 { SELECT count(*) FROM uu WHERE rowid > 75 } {25}
281 do_execsql_test 3.6.7 { SELECT count(*) FROM uu WHERE rowid > 76 } {24}
282 do_execsql_test 3.6.8 { SELECT count(*) FROM uu WHERE rowid > 99 } {1}
283 do_execsql_test 3.6.9 { SELECT count(*) FROM uu WHERE rowid > 100 } {0}
284 do_execsql_test 3.6.10 { SELECT count(*) FROM uu WHERE rowid > 101 } {0}
286 do_execsql_test 3.7.1 { SELECT count(*) FROM uu WHERE rowid >= 24 } {277}
287 do_execsql_test 3.7.1 { SELECT count(*) FROM uu WHERE rowid >= 25 } {276}
288 do_execsql_test 3.7.2 { SELECT count(*) FROM uu WHERE rowid >= 26 } {200}
289 do_execsql_test 3.7.3 { SELECT count(*) FROM uu WHERE rowid >= 27 } {174}
290 do_execsql_test 3.7.4 { SELECT count(*) FROM uu WHERE rowid >= 73 } {128}
291 do_execsql_test 3.7.5 { SELECT count(*) FROM uu WHERE rowid >= 74 } {127}
292 do_execsql_test 3.7.6 { SELECT count(*) FROM uu WHERE rowid >= 75 } {100}
293 do_execsql_test 3.7.7 { SELECT count(*) FROM uu WHERE rowid >= 76 } {25}
294 do_execsql_test 3.7.8 { SELECT count(*) FROM uu WHERE rowid >= 99 } {2}
295 do_execsql_test 3.7.9 { SELECT count(*) FROM uu WHERE rowid >= 100 } {1}
296 do_execsql_test 3.7.10 { SELECT count(*) FROM uu WHERE rowid >= 101 } {0}
301 do_execsql_test 3.8.1 { SELECT count(*) FROM uu WHERE rowid >= $S } {300}
302 do_execsql_test 3.8.2 { SELECT count(*) FROM uu WHERE rowid > $S } {300}
303 do_execsql_test 3.8.3 { SELECT count(*) FROM uu WHERE rowid <= $S } {0}
304 do_execsql_test 3.8.4 { SELECT count(*) FROM uu WHERE rowid < $S } {0}
306 do_execsql_test 3.9.1 { SELECT count(*) FROM uu WHERE rowid >= $L } {0}
307 do_execsql_test 3.9.2 { SELECT count(*) FROM uu WHERE rowid > $L } {0}
308 do_execsql_test 3.9.3 { SELECT count(*) FROM uu WHERE rowid <= $L } {300}
309 do_execsql_test 3.9.4 { SELECT count(*) FROM uu WHERE rowid < $L } {300}
354 do_execsql_test 4.2.$v { SELECT * FROM sl WHERE rowid=$k } [list $k $v]
358 SELECT * FROM sl WHERE rowid>-9223372036854775808
364 SELECT * FROM sl WHERE rowid>=-9223372036854775808
370 SELECT * FROM sl WHERE rowid<=-9223372036854775808
375 SELECT * FROM sl WHERE rowid<-9223372036854775808
379 SELECT * FROM sl WHERE rowid<9223372036854775807
385 SELECT * FROM sl WHERE rowid<=9223372036854775807
391 SELECT * FROM sl WHERE rowid>=9223372036854775807
396 SELECT * FROM sl WHERE rowid>9223372036854775807
446 SELECT y.one FROM cc AS x, cc AS y WHERE x.one=y.one AND x.rowid>5
450 SELECT cc.one FROM c4, cc WHERE cc.rowid>c4.rowid