Lines Matching refs:LIMIT
13 # focus of this file is testing the LIMIT ... OFFSET ... clause
39 execsql {SELECT count(*) FROM t1 LIMIT 5}
42 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
45 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
48 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
51 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
54 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
57 execsql {SELECT x FROM t1 ORDER BY x LIMIT 30, 50}
60 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
63 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5}
66 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5 OFFSET 32}
71 CREATE VIEW v1 AS SELECT * FROM t1 LIMIT 2;
77 CREATE TABLE t2 AS SELECT * FROM t1 LIMIT 2;
83 SELECT count(*) FROM t1 WHERE rowid IN (SELECT rowid FROM t1 LIMIT 2);
89 SELECT z FROM (SELECT y*10+x AS z FROM t1 ORDER BY x LIMIT 10)
90 ORDER BY z LIMIT 5;
98 INSERT INTO t3 SELECT x FROM t1 ORDER BY x LIMIT 10 OFFSET 1;
115 SELECT x FROM t3 LIMIT 2 OFFSET 10000
126 FROM t3 LIMIT 1000;
127 SELECT x FROM t4 ORDER BY y DESC LIMIT 1 OFFSET 999;
135 ORDER BY x LIMIT 2;
143 ORDER BY x DESC LIMIT 2;
150 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x ORDER BY x DESC LIMIT 31;
151 SELECT * FROM t5 ORDER BY x LIMIT 2;
156 SELECT * FROM t5 ORDER BY x DESC, y DESC LIMIT 2;
163 ORDER BY 1, 2 LIMIT 1000;
168 # There is some contraversy about whether LIMIT 0 should be the same as
169 # no limit at all or if LIMIT 0 should result in zero output rows.
184 SELECT * FROM t6 LIMIT -1 OFFSET -1;
189 SELECT * FROM t6 LIMIT 2 OFFSET -123;
194 SELECT * FROM t6 LIMIT -432 OFFSET 2;
199 SELECT * FROM t6 LIMIT -1
204 SELECT * FROM t6 LIMIT -1 OFFSET 1
209 SELECT * FROM t6 LIMIT 0
214 SELECT * FROM t6 LIMIT 0 OFFSET 1
218 # Make sure LIMIT works well with compound SELECT statements.
223 SELECT x FROM t2 LIMIT 5 UNION ALL SELECT a FROM t6;
225 } {1 {LIMIT clause should come after UNION ALL not before}}
228 SELECT x FROM t2 LIMIT 5 UNION SELECT a FROM t6;
230 } {1 {LIMIT clause should come after UNION not before}}
233 SELECT x FROM t2 LIMIT 5 EXCEPT SELECT a FROM t6 LIMIT 3;
235 } {1 {LIMIT clause should come after EXCEPT not before}}
238 SELECT x FROM t2 LIMIT 0,5 INTERSECT SELECT a FROM t6;
240 } {1 {LIMIT clause should come after INTERSECT not before}}
243 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 5;
248 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 3 OFFSET 1;
253 SELECT x FROM t2 UNION ALL SELECT a FROM t6 ORDER BY 1 LIMIT 3 OFFSET 1;
258 SELECT x FROM t2 UNION SELECT x+2 FROM t2 LIMIT 2 OFFSET 1;
263 SELECT x FROM t2 UNION SELECT x+2 FROM t2 ORDER BY 1 DESC LIMIT 2 OFFSET 1;
268 SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 LIMIT 2;
273 SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 ORDER BY 1 DESC LIMIT 2;
278 SELECT a+26 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
283 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
288 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1 OFFSET 1;
294 ORDER BY 1 DESC LIMIT 1 OFFSET 1;
303 SELECT DISTINCT round(x/100) FROM t3 LIMIT 5;
308 SELECT DISTINCT round(x/100) FROM t3 LIMIT 5 OFFSET 5;
313 SELECT DISTINCT round(x/100) FROM t3 LIMIT 5 OFFSET 25;