Lines Matching refs:AS
26 WITH x(a) AS ( SELECT * FROM t1) SELECT 10
30 SELECT * FROM ( WITH x AS ( SELECT * FROM t1) SELECT 10 );
34 WITH x(a) AS ( SELECT * FROM t1) INSERT INTO t1 VALUES(1,2);
38 WITH x(a) AS ( SELECT * FROM t1) DELETE FROM t1;
42 WITH x(a) AS ( SELECT * FROM t1) UPDATE t1 SET x = y;
52 WITH tmp AS ( SELECT * FROM t1 ) SELECT x FROM tmp;
56 WITH tmp(a) AS ( SELECT * FROM t1 ) SELECT a FROM tmp;
61 WITH tmp(a) AS ( SELECT * FROM t1 ) SELECT a FROM tmp
66 WITH tmp1(a) AS ( SELECT * FROM t1 ),
67 tmp2(x) AS ( SELECT * FROM tmp1)
72 WITH tmp2(x) AS ( SELECT * FROM tmp1),
73 tmp1(a) AS ( SELECT * FROM t1 )
79 WITH tmp2(x) AS ( SELECT * FROM tmp1 ),
80 tmp1(a) AS ( SELECT * FROM tmp2 )
86 WITH tmp(a) AS (SELECT * FROM t1),
87 tmp(a) AS (SELECT * FROM t1)
98 WITH t3(a) AS (SELECT * FROM t4)
103 WITH tmp AS ( SELECT * FROM t3 ),
104 tmp2 AS ( WITH tmp AS ( SELECT * FROM t4 ) SELECT * FROM tmp )
109 WITH tmp AS ( SELECT * FROM t3 ),
110 tmp2 AS ( WITH xxxx AS ( SELECT * FROM t4 ) SELECT * FROM tmp )
115 WITH tmp AS ( SELECT * FROM t3 ),
128 WITH dset AS ( SELECT 2 UNION ALL SELECT 4 )
134 WITH iset AS ( SELECT 2 UNION ALL SELECT 4 )
140 WITH uset(a, b) AS ( SELECT 2, 8 UNION ALL SELECT 4, 9 )
148 WITH i(x) AS ( VALUES(1) UNION ALL SELECT x+1 FROM i)
153 WITH i(x) AS ( VALUES(1) UNION ALL SELECT x+1 FROM i ORDER BY 1)
173 ancest(id, mtime) AS
184 ancest(id, mtime) AS
195 ancest(id, mtime) AS
206 WITH i(x) AS ( VALUES(1) UNION ALL SELECT x+1 FROM i LIMIT 5)
211 WITH i(x) AS ( VALUES(1) UNION ALL SELECT (x+1)%10 FROM i)
216 WITH i(x) AS ( VALUES(1) UNION SELECT (x+1)%10 FROM i)
221 WITH i(x, y) AS ( VALUES(1) )
226 WITH i(x) AS ( VALUES(1,2) )
232 WITH i(x) AS ( SELECT * FROM t5 )
237 WITH i(x) AS ( SELECT 1, 2 UNION ALL SELECT 1 )
242 WITH i(x) AS ( SELECT 1 UNION ALL SELECT 1, 2 )
247 WITH i(x) AS ( SELECT 1 UNION ALL SELECT x+1, x*2 FROM i )
252 WITH i(x) AS ( SELECT 1, 2 UNION SELECT x+1 FROM i )
281 WITH flat(fid, fpath) AS (
301 WITH flat(fid, fpath) AS (
310 WITH x(i) AS (
331 WITH t(id, path) AS (
340 WITH t(id) AS (
349 WITH t(id) AS (
358 WITH t(id) AS (
367 WITH t(id) AS (
379 xaxis(x) AS (VALUES(-2.0) UNION ALL SELECT x+0.05 FROM xaxis WHERE x<1.2),
380 yaxis(y) AS (VALUES(-1.0) UNION ALL SELECT y+0.1 FROM yaxis WHERE y<1.0),
381 m(iter, cx, cy, x, y) AS (
387 m2(iter, cx, cy) AS (
390 a(t) AS (
422 input(sud) AS (
427 digits(z, lp) AS (
430 CAST(lp+1 AS TEXT), lp+1 FROM digits WHERE lp<9
434 x(s, ind) AS (
440 FROM x, digits AS z
444 FROM digits AS lp
467 WITH ii(a) AS (
522 WITH flat(fid, p) AS (
548 WITH flat(fid, depth, p) AS (
613 WITH t(a) AS (
614 SELECT 1 AS b UNION ALL SELECT a+1 AS c FROM t WHERE a<5 ORDER BY a
619 WITH t(a) AS (
620 SELECT 1 AS b UNION ALL SELECT a+1 AS c FROM t WHERE a<5 ORDER BY b
625 WITH t(a) AS (
626 SELECT 1 AS b UNION ALL SELECT a+1 AS c FROM t WHERE a<5 ORDER BY c
646 WITH flat(fid, depth, p) AS (
658 WITH flat(fid, depth, p) AS (
673 WITH flat(fid, depth, p) AS (
732 under_alice(name,level) AS (
763 under_alice(name,level) AS (
794 under_alice(name,level) AS (
825 t1(x) AS (VALUES(2) UNION ALL SELECT x+2 FROM t1 WHERE x<20),
826 t2(y) AS (VALUES(3) UNION ALL SELECT y+3 FROM t2 WHERE y<20)
834 WITH RECURSIVE c(i) AS (SELECT * UNION ALL SELECT i+1 FROM c WHERE i<10)
838 WITH RECURSIVE c(i) AS (SELECT 5,* UNION ALL SELECT i+1 FROM c WHERE i<10)
842 WITH RECURSIVE c(i,j) AS (SELECT 5,* UNION ALL SELECT i+1,11 FROM c WHERE i<10)
849 WITH x AS (SELECT * FROM t) SELECT 0 EXCEPT SELECT 0 ORDER BY 1 COLLATE binary;
856 d(x) AS (VALUES(1) UNION ALL SELECT rowid+1 FROM d WHERE rowid<10)
864 i(x) AS (VALUES(1) UNION SELECT count(*) FROM i)
873 i(x) AS (VALUES(1) UNION SELECT count(*) OVER () FROM i)
878 t(id, parent) AS (VALUES(1,2)),
879 q(id, parent, rn) AS (
882 SELECT t.*, ROW_NUMBER() OVER (ORDER BY t.id) AS rn
891 WITH x(a) AS (
892 WITH y(b) AS (SELECT 10)
899 WITH x AS (
900 WITH y(b) AS (SELECT 10)
908 WITH x AS (
909 WITH y(b) AS (SELECT 10)
920 WITH i AS (
921 WITH j AS (SELECT 5)
928 WITH i AS (
929 WITH j AS (SELECT 5)
937 x1 AS (SELECT 10),
938 x2 AS (SELECT * FROM x1),
939 x3 AS (
940 WITH x1 AS (SELECT 11)
948 x1 AS (SELECT 10),
949 x2 AS (SELECT * FROM x1),
950 x3 AS (
951 WITH x1 AS (SELECT 11)
959 x1 AS (SELECT 10),
960 x2 AS (SELECT * FROM x1),
961 x3 AS (
963 x1 AS ( SELECT 11 ),
964 x4 AS ( SELECT * FROM x2 )
972 x1 AS (SELECT 10),
973 x2 AS (SELECT * FROM x1),
974 x3 AS (
976 x1 AS ( SELECT 11 ),
977 x4 AS ( SELECT * FROM x2 )
985 x1 AS (SELECT 10),
986 x2 AS (SELECT 11),
987 x3 AS (
990 x4 AS (
992 x1 AS (SELECT 12),
993 x2 AS (SELECT 13)
1002 WITH xyz(x) AS (VALUES(NULL) UNION SELECT round(1<x) FROM xyz ORDER BY 1)
1006 WITH xyz(x) AS (
1022 x1(a) AS (values(100))
1024 SELECT * FROM (WITH x2(y) AS (SELECT * FROM x1) SELECT y+a FROM x1, x2);
1041 WITH c(i)AS(VALUES(9)UNION SELECT~i FROM c)SELECT max(5)>i fROM c;
1044 WITH c(i)AS(VALUES(5)UNIoN SELECT 0)SELECT min(1)-i fROM c;
1053 WITH RECURSIVE t21(a,b) AS (
1054 WITH t21(x) AS (VALUES(1))
1057 SELECT * FROM t21 AS tA, t21 AS tB
1061 WITH RECURSIVE t21(a,b) AS (
1062 WITH t21(x) AS (VALUES(1))
1065 SELECT * FROM t21 AS tA, t21 AS tB
1069 EXISTS (WITH RECURSIVE Table0 AS (WITH Table0 AS (SELECT DISTINCT 1)
1078 WITH RECURSIVE c AS NOT MATERIALIZED (
1079 WITH RECURSIVE c AS NOT MATERIALIZED (
1080 WITH RECURSIVE c AS NOT MATERIALIZED (
1081 WITH RECURSIVE c AS NOT MATERIALIZED (
1082 WITH c AS (VALUES(0))
1105 CREATE VIEW v2 AS
1106 WITH t4(Name) AS (VALUES ('A'), ('B'))
1108 CREATE VIEW v3 AS
1109 WITH t4(Att, Val, Act) AS (VALUES
1124 CREATE VIEW v1 AS SELECT max(a), min(b) FROM t1 GROUP BY c;
1131 ATTACH "" AS aux;
1132 CREATE VIEW aux.v3 AS VALUES(1);
1133 CREATE VIEW main.v3 AS VALUES(3);
1135 CREATE VIEW aux.v2 AS SELECT * FROM v3;
1136 CREATE VIEW main.v2 AS SELECT * FROM v3;
1138 SELECT * FROM main.v2 AS a, aux.v2 AS b, aux.v2 AS c, main.v2 AS d;
1153 1 {CREATE TABLE dual AS SELECT 'X' AS dummy}
1154 2 {CREATE TEMP TABLE dual AS SELECT 'X' AS dummy}
1155 3 {CREATE VIEW dual(dummy) AS VALUES('X')}
1156 4 {CREATE TEMP VIEW dual(dummy) AS VALUES('X')}
1161 WITH cte1 AS (
1163 WITH cte2 AS (SELECT avg(DISTINCT TRUE) FROM dual)
1165 ) AS subquery1
1174 WITH i(x) AS (
1189 WITH RECURSIVE cte(label, step) AS (
1197 WITH RECURSIVE cte(label, step) AS (
1208 WITH RECURSIVE cte(label, step) AS (
1228 WITH map(k,v) AS (VALUES(1,'cte1'),(2,'cte2'))