Lines Matching refs:x
23 CREATE TABLE t1(x int, y int);
41 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
44 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
47 execsql {SELECT x FROM t1 ORDER BY x+1 LIMIT 5 OFFSET -2}
50 execsql {SELECT x FROM t1 ORDER BY x+1 LIMIT 2, -5}
53 execsql {SELECT x FROM t1 ORDER BY x+1 LIMIT -2, 5}
56 execsql {SELECT x FROM t1 ORDER BY x+1 LIMIT -2, -5}
59 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
62 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
65 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
68 execsql {SELECT x FROM t1 ORDER BY x LIMIT 30, 50}
71 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
74 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5}
77 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5 OFFSET 32}
105 SELECT z FROM (SELECT y*10+x AS z FROM t1 ORDER BY x LIMIT 10)
115 CREATE TABLE t3(x);
116 INSERT INTO t3 SELECT x FROM t1 ORDER BY x LIMIT 10 OFFSET 1;
117 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
118 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
119 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
120 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
121 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
122 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
123 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
124 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
125 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
126 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
133 CREATE TABLE t3(x);
134 INSERT INTO t3 SELECT x FROM t1 ORDER BY x LIMIT 10 OFFSET 1;
137 set max_x_t3 [execsql {SELECT max(x) FROM t3}]
138 execsql "INSERT INTO t3 SELECT x+$max_x_t3 FROM t3;"
148 SELECT x FROM t3 LIMIT 2 OFFSET 10000
153 CREATE TABLE t4 AS SELECT x,
154 'abcdefghijklmnopqrstuvwyxz ABCDEFGHIJKLMNOPQRSTUVWYXZ' || x ||
155 'abcdefghijklmnopqrstuvwyxz ABCDEFGHIJKLMNOPQRSTUVWYXZ' || x ||
156 'abcdefghijklmnopqrstuvwyxz ABCDEFGHIJKLMNOPQRSTUVWYXZ' || x ||
157 'abcdefghijklmnopqrstuvwyxz ABCDEFGHIJKLMNOPQRSTUVWYXZ' || x ||
158 'abcdefghijklmnopqrstuvwyxz ABCDEFGHIJKLMNOPQRSTUVWYXZ' || x AS y
160 SELECT x FROM t4 ORDER BY y DESC LIMIT 1 OFFSET 999;
166 CREATE TABLE t5(x,y);
167 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
168 ORDER BY x LIMIT 2;
169 SELECT * FROM t5 ORDER BY x;
175 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
176 ORDER BY x DESC LIMIT 2;
177 SELECT * FROM t5 ORDER BY x;
183 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x ORDER BY x DESC LIMIT 31;
184 SELECT * FROM t5 ORDER BY x LIMIT 2;
189 SELECT * FROM t5 ORDER BY x DESC, y DESC LIMIT 2;
195 INSERT INTO t5 SELECT a.x*100+b.x, a.y*100+b.y FROM t1 AS a, t1 AS b
197 SELECT count(*), sum(x), sum(y), min(x), max(x), min(y), max(y) FROM t5;
263 SELECT x FROM t2 LIMIT 5 UNION ALL SELECT a FROM t6;
268 SELECT x FROM t2 LIMIT 5 UNION SELECT a FROM t6;
273 SELECT x FROM t2 LIMIT 5 EXCEPT SELECT a FROM t6 LIMIT 3;
278 SELECT x FROM t2 LIMIT 0,5 INTERSECT SELECT a FROM t6;
283 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 5;
288 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 3 OFFSET 1;
293 SELECT x FROM t2 UNION ALL SELECT a FROM t6 ORDER BY 1 LIMIT 3 OFFSET 1;
298 SELECT x FROM t2 UNION SELECT x+2 FROM t2 LIMIT 2 OFFSET 1;
303 SELECT x FROM t2 UNION SELECT x+2 FROM t2 ORDER BY 1 DESC LIMIT 2 OFFSET 1;
318 SELECT a+26 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
323 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
328 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1 OFFSET 1;
333 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2
344 SELECT DISTINCT cast(round(x/100) as integer) FROM t3 LIMIT 5;
349 SELECT DISTINCT cast(round(x/100) as integer) FROM t3 LIMIT 5 OFFSET 5;
354 SELECT DISTINCT cast(round(x/100) as integer) FROM t3 LIMIT 5 OFFSET 25;
413 SELECT x FROM t1 LIMIT :limit;
420 SELECT x FROM t1 LIMIT :limit OFFSET :offset;
426 SELECT x FROM t1 WHERE x<10 LIMIT :limit;
433 SELECT x FROM t1 WHERE x<10 LIMIT :limit;
441 SELECT x FROM t1 WHERE x<10 LIMIT :limit;
449 SELECT x FROM (SELECT x FROM t1 ORDER BY x LIMIT 0) ORDER BY x
468 SELECT * FROM t1 LIMIT x
470 } {1 {no such column: x}}
473 SELECT * FROM t1 LIMIT 1 OFFSET x
475 } {1 {no such column: x}}
482 CREATE TABLE t13(x);
484 CREATE VIEW v13a AS SELECT x AS y FROM t13;