Lines Matching refs:LIMIT

15 # focus of this file is testing the LIMIT ... OFFSET ... clause
41 execsql {SELECT count(*) FROM t1 LIMIT 5}
44 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
47 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
50 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
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}
59 execsql {SELECT x FROM t1 ORDER BY x LIMIT 30, 50}
62 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
65 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5}
68 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5 OFFSET 32}
73 CREATE VIEW v1 AS SELECT * FROM t1 LIMIT 2;
79 CREATE TABLE t2 AS SELECT * FROM t1 LIMIT 2;
85 SELECT count(*) FROM t1 WHERE rowid IN (SELECT rowid FROM t1 LIMIT 2);
91 SELECT z FROM (SELECT y*10+x AS z FROM t1 ORDER BY x LIMIT 10)
92 ORDER BY z LIMIT 5;
100 INSERT INTO t3 SELECT x FROM t1 ORDER BY x LIMIT 10 OFFSET 1;
117 SELECT x FROM t3 LIMIT 2 OFFSET 10000
128 FROM t3 LIMIT 1000;
129 SELECT x FROM t4 ORDER BY y DESC LIMIT 1 OFFSET 999;
137 ORDER BY x LIMIT 2;
145 ORDER BY x DESC LIMIT 2;
152 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x ORDER BY x DESC LIMIT 31;
153 SELECT * FROM t5 ORDER BY x LIMIT 2;
158 SELECT * FROM t5 ORDER BY x DESC, y DESC LIMIT 2;
165 ORDER BY 1, 2 LIMIT 1000;
170 # There is some contraversy about whether LIMIT 0 should be the same as
171 # no limit at all or if LIMIT 0 should result in zero output rows.
186 SELECT * FROM t6 LIMIT -1 OFFSET -1;
191 SELECT * FROM t6 LIMIT 2 OFFSET -123;
196 SELECT * FROM t6 LIMIT -432 OFFSET 2;
201 SELECT * FROM t6 LIMIT -1
206 SELECT * FROM t6 LIMIT -1 OFFSET 1
211 SELECT * FROM t6 LIMIT 0
216 SELECT * FROM t6 LIMIT 0 OFFSET 1
220 # Make sure LIMIT works well with compound SELECT statements.
225 SELECT x FROM t2 LIMIT 5 UNION ALL SELECT a FROM t6;
227 } {1 {LIMIT clause should come after UNION ALL not before}}
230 SELECT x FROM t2 LIMIT 5 UNION SELECT a FROM t6;
232 } {1 {LIMIT clause should come after UNION not before}}
235 SELECT x FROM t2 LIMIT 5 EXCEPT SELECT a FROM t6 LIMIT 3;
237 } {1 {LIMIT clause should come after EXCEPT not before}}
240 SELECT x FROM t2 LIMIT 0,5 INTERSECT SELECT a FROM t6;
242 } {1 {LIMIT clause should come after INTERSECT not before}}
245 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 5;
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;
270 SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 LIMIT 2;
275 SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 ORDER BY 1 DESC LIMIT 2;
280 SELECT a+26 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
285 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 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;
305 SELECT DISTINCT round(x/100) FROM t3 LIMIT 5;
310 SELECT DISTINCT round(x/100) FROM t3 LIMIT 5 OFFSET 5;
315 SELECT DISTINCT round(x/100) FROM t3 LIMIT 5 OFFSET 25;