Lines Matching refs:seq
228 # This test case starts a linear scan of table 'seq' using a
230 # to the end of the seq table (ahead of the current cursor position).
233 CREATE TABLE seq(i PRIMARY KEY, x);
234 INSERT INTO seq VALUES(1, '[string repeat X 500]');
235 INSERT INTO seq VALUES(2, '[string repeat X 500]');
241 db2 eval {SELECT i FROM seq ORDER BY i} {
243 set max [execsql {SELECT max(i) FROM seq}]
245 INSERT INTO seq SELECT i + :max, x FROM seq;
253 # Another linear scan through table seq using a read-uncommitted connection.
258 db2 eval {SELECT i FROM seq} {
259 db eval {DELETE FROM seq WHERE i = :i}
266 SELECT * FROM seq;