Lines Matching refs:x

25   CREATE TABLE %t1(%x, %y %typename);
36   3 { set A(%x)  over }
39     set A(%x)       following 
44     set A(%x)       following 
52     set A(%x)       window 
56   set A(%x)     x
69     SELECT group_concat(%x, '.') OVER (ORDER BY %y) FROM %t1
73     SELECT sum(%x) OVER %w FROM %t1 WINDOW %w AS (ORDER BY %y)
77     SELECT sum(%alias.%x) OVER %w FROM %t1 %alias WINDOW %w AS (ORDER BY %y)
81     SELECT sum(%x) %alias FROM %t1
95   CREATE TABLE window(x COLLATE window);
97   SELECT * FROM window ORDER BY x COLLATE window;
101   CREATE TABLE x1(x);
103   CREATE INDEX window ON x1(x COLLATE window);
104   SELECT * FROM x1 ORDER BY x COLLATE window;
108 do_execsql_test 4.0 { CREATE TABLE t4(x, y); }
119   CREATE TABLE over(x, over);
120   CREATE TABLE window(x, window);
123   SELECT sum(x) over FROM over
127   SELECT sum(x) over over FROM over WINDOW over AS ()
144   WINDOW win AS (ORDER BY x ROWS BETWEEN +2 FOLLOWING AND +3 FOLLOWING)
153     SELECT LIKE('!', '', '!') x WHERE x;
165   CREATE TABLE t1(x TEXT);
166   CREATE INDEX i1 ON t1(x COLLATE nocase);
172     SELECT count(*) FROM t1 WHERE x LIKE '!' ESCAPE '!';
217   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
218   SELECT x, group_concat(x) OVER (ORDER BY x ROWS 2 PRECEDING)
224 #  WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
225 #  SELECT x, group_concat(x) OVER (ORDER BY x RANGE 2 PRECEDING)
230 #  WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
231 #  SELECT x, group_concat(x) OVER (ORDER BY x RANGE BETWEEN UNBOUNDED PRECEDING AND 2 FOLLOWING)
236   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
237   SELECT count(DISTINCT x) OVER (ORDER BY x) FROM c;
241   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
242   SELECT count() OVER (ORDER BY x RANGE UNBOUNDED FOLLOWING) FROM c;
246   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
247   SELECT count() OVER (ORDER BY x RANGE BETWEEN UNBOUNDED FOLLOWING AND UNBOUNDED FOLLOWING) FROM c;
251   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
252   SELECT count() OVER (ORDER BY x RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED PRECEDING) FROM c;
262     WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
264         ORDER BY x ROWS $frame 
270   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
272       ORDER BY x ROWS BETWEEN a PRECEDING AND 2 FOLLOWING
276   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
278       ORDER BY x ROWS BETWEEN 2 PRECEDING AND a FOLLOWING
323   CREATE TABLE t3(x INT, y VARCHAR);
324   INSERT INTO t3(x,y) VALUES(10,'ten'),('15','fifteen'),(30,'thirty');
328   SELECT a, (SELECT y FROM t3 WHERE x=a) FROM t1 ORDER BY a;
334   SELECT a, (SELECT y FROM t3 WHERE x=a), sum(a) OVER (ORDER BY a)