Lines Matching refs:OFFSET

15 # focus of this file is testing the LIMIT ... OFFSET ... clause
47   execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
53   execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
56   execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
62   execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
68   execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5 OFFSET 32}
100     INSERT INTO t3 SELECT x FROM t1 ORDER BY x LIMIT 10 OFFSET 1;
117     SELECT x FROM t3 LIMIT 2 OFFSET 10000
129     SELECT x FROM t4 ORDER BY y DESC LIMIT 1 OFFSET 999;
186     SELECT * FROM t6 LIMIT -1 OFFSET -1;
191     SELECT * FROM t6 LIMIT 2 OFFSET -123;
196     SELECT * FROM t6 LIMIT -432 OFFSET 2;
206     SELECT * FROM t6 LIMIT -1 OFFSET 1
216     SELECT * FROM t6 LIMIT 0 OFFSET 1
250     SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 3 OFFSET 1;
255     SELECT x FROM t2 UNION ALL SELECT a FROM t6 ORDER BY 1 LIMIT 3 OFFSET 1;
260     SELECT x FROM t2 UNION SELECT x+2 FROM t2 LIMIT 2 OFFSET 1;
265     SELECT x FROM t2 UNION SELECT x+2 FROM t2 ORDER BY 1 DESC LIMIT 2 OFFSET 1;
290     SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1 OFFSET 1;
296        ORDER BY 1 DESC LIMIT 1 OFFSET 1;
310     SELECT DISTINCT round(x/100) FROM t3 LIMIT 5 OFFSET 5;
315     SELECT DISTINCT round(x/100) FROM t3 LIMIT 5 OFFSET 25;