Home
last modified time | relevance | path

Searched refs:AS (Results 1 – 25 of 580) sorted by relevance

12345678910>>...24

/sqlite-3.40.0/test/
H A Dcast.test25 # Tests for the CAST( AS blob), CAST( AS text) and CAST( AS numeric) built-ins
241 execsql {SELECT CAST(CAST(9223372036854774800 AS real) AS integer)}
253 execsql {SELECT CAST(CAST(-9223372036854774800 AS real) AS integer)}
266 execsql {SELECT CAST(CAST('9223372036854774800' AS real) AS integer)}
280 execsql {SELECT CAST(CAST('-9223372036854774800' AS real) AS integer)}
342 SELECT CAST(a AS integer), a, CAST(a AS real), a FROM t1;
395 SELECT CAST('-' AS NUMERIC);
401 SELECT CAST('+' AS NUMERIC);
404 SELECT CAST('/' AS NUMERIC);
442 SELECT CAST('.' AS numeric);
[all …]
H A Dwith2.test66 CREATE TABLE t3 AS SELECT 3 AS x;
67 CREATE TABLE t4 AS SELECT 4 AS x;
70 x2 AS (
78 WITH x2 AS (
86 WITH x2 AS (
105 i(x) AS (
141 t4(x) AS (
221 i(x) AS (
424 SELECT * FROM xyz AS one, xyz AS two, (
611 …CREATE VIEW v2(c) AS WITH x AS (WITH y AS (WITH z AS(SELECT * FROM t1) SELECT * FROM v2) SELECT a)…
[all …]
H A Dwith1.test939 x3 AS (
950 x3 AS (
961 x3 AS (
974 x3 AS (
987 x3 AS (
990 x4 AS (
1057 SELECT * FROM t21 AS tA, t21 AS tB
1065 SELECT * FROM t21 AS tA, t21 AS tB
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}
[all …]
H A Dwith3.test28 WITH i(x) AS (
48 x1 AS (SELECT 10),
49 x2 AS (SELECT 11),
50 x3 AS (
53 x4 AS (
146 WITH t1 AS (SELECT 1 AS c1 GROUP BY 1)
147 SELECT a.c1 FROM t1 AS a, t1 AS b
190 SELECT t4a.d FROM t4 AS t4a JOIN t4 AS t4b LEFT JOIN t4 AS t4c
194 SELECT t2a.b FROM t2 AS t2a JOIN t2 AS t2x
206 SELECT x1.x||x2.x||x3.x||x4.x FROM c AS x1, c AS x2, c AS x3, c AS x4
[all …]
H A Dbadutf.test23 sqlite3_exec db {SELECT hex('%80') AS x}
26 sqlite3_exec db {SELECT hex('%81') AS x}
29 sqlite3_exec db {SELECT hex('%bf') AS x}
32 sqlite3_exec db {SELECT hex('%c0') AS x}
35 sqlite3_exec db {SELECT hex('%e0') AS x}
38 sqlite3_exec db {SELECT hex('%f0') AS x}
41 sqlite3_exec db {SELECT hex('%ff') AS x}
48 sqlite3_exec db2 {SELECT hex('%80') AS x}
51 sqlite3_exec db2 {SELECT hex('%81') AS x}
85 sqlite3_exec db {SELECT '%80'=CAST(x'80' AS text) AS x}
[all …]
H A Dwith6.test25 WITH c(x) AS (VALUES(0),(1))
29 WITH c(x) AS (VALUES(0),(1))
140 WITH c(x) AS (VALUES(0),(1))
147 WITH c(x) AS (VALUES(0),(1))
168 WITH c(x) AS (VALUES(0),(1))
170 FROM c AS c2 WHERE c2.x<10;
173 WITH c(x) AS (VALUES(0),(1))
175 FROM c AS c2 WHERE c2.x<10;
209 CREATE VIEW t2(y) AS
219 CREATE VIEW t2(y) AS
[all …]
H A Dview.test187 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
229 SELECT b AS 'x', a AS 'y' FROM t1
293 SELECT * FROM v5 AS a, t2 AS b WHERE a.w=b.y;
303 SELECT * FROM t2 AS b, v5 AS a WHERE a.w=b.y;
313 SELECT * FROM t1 AS a, v5 AS b, t2 AS c WHERE a.x=b.v AND b.w=c.y;
318 EXPLAIN SELECT * FROM t1 AS a, v5 AS b, t2 AS c WHERE a.x=b.v AND b.w=c.y;
409 CREATE VIEW v8 AS SELECT max(cnt) AS mx FROM
556 CREATE VIEW v15 AS SELECT a AS x, b AS y FROM t1;
575 } {{CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1}}
655 CREATE VIEW x1 AS SELECT 123 AS '', 234 AS '', 345 AS '';
[all …]
H A Dselect6.test256 (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
355 SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c')
360 SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c' WHERE 0)
365 SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c' WHERE 1)
405 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
406 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
416 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
417 (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
425 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
434 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
[all …]
H A Dtkt3527.test58 CREATE VIEW ElemView1 AS
60 CAST(Element.Code AS VARCHAR(50)) AS ElemId,
64 ElemAnd.Attr1 AS Attr1,
67 0 AS Level,
68 0 AS IsOrElem
73 CAST(ElemOr.CodeOr AS VARCHAR(50)) AS ElemId,
77 NULL AS Attr1,
78 NULL AS Attr2,
79 NULL AS Attr3,
80 0 AS Level,
[all …]
H A Dgencol1.test168 c1 a UNIQUE AS (1),
185 gcb AS (b*1),
187 gcc AS (c+0),
189 gca AS (1*a+0),
199 gcid AS (1*id)
242 b AS(c) NOT NULL,
259 b AS(a) NOT NULL,
295 c1 AS (1),
305 c1 AS(c0 + c2),
441 CREATE TABLE t0(c0 AS(1 >= 1), c1 UNIQUE AS(TYPEOF(c0)), c2);
[all …]
H A Daltertab3.test286 w1 AS
290 w1 AS
293 d AS
297 w2 AS
299 w3 AS
305 w1 AS
308 d AS
353 SELECT (WITH t2 AS (WITH t3 AS (SELECT true)
435 AS)AS)AS)AS)AS)AS)AS)AS)AS)AS)AS)WINDOW x AS(RANGE BETWEEN UNBOUNDED
513 CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) VALUES(1);
[all …]
H A DselectC.test27 SELECT DISTINCT a AS x, b||c AS y
34 SELECT DISTINCT a AS x, b||c AS y
41 SELECT DISTINCT a AS x, b||c AS y
48 SELECT DISTINCT a AS x, b||c AS y
55 SELECT DISTINCT a AS x, b||c AS y
62 SELECT DISTINCT a AS x, b||c AS y
69 SELECT DISTINCT a AS x, b||c AS y
76 SELECT a AS x, b||c AS y
84 SELECT a AS x, b||c AS y
92 SELECT a AS x, b||c AS y
[all …]
H A Dresolver01.test34 SELECT 1 AS y FROM t1, t2 ORDER BY y;
45 SELECT x AS y FROM t3 ORDER BY y;
50 SELECT x AS yy FROM t3 ORDER BY y;
59 SELECT x AS yy FROM t3 ORDER BY yy;
64 SELECT x AS yy FROM t3 ORDER BY 1;
125 SELECT x AS y FROM t3 ORDER BY +y;
130 SELECT x AS yy FROM t3 ORDER BY +y;
135 SELECT x AS yy FROM t3 ORDER BY +yy
201 NULLIF(name,'abc') AS name
207 SELECT 2 AS x WHERE (SELECT x AS y WHERE 3>y);
[all …]
H A Dselect4.test574 SELECT 0 AS x, 1 AS y
576 SELECT 2 AS p, 3 AS q
578 SELECT 4 AS a, 5 AS b
587 SELECT 0 AS x, 1 AS y
610 SELECT 0 AS x, 1 AS y
612 SELECT 2 AS y, -3 AS x
619 SELECT 1 AS a, 2 AS b UNION ALL SELECT 3 AS b, 4 AS a
626 SELECT * FROM (SELECT 1 AS a, 2 AS b UNION ALL SELECT 3 AS b, 4 AS a)
632 SELECT * FROM (SELECT 1 AS a, 2 AS b UNION ALL SELECT 3 AS b, 4 AS a)
638 SELECT * FROM (SELECT 1 AS a, 2 AS b UNION ALL SELECT 3 AS e, 4 AS b)
[all …]
H A Daltertab.test101 CREATE VIEW uuu AS SELECT main.one.a, one.b, c FROM txx AS one;
122 } {{CREATE VIEW uuu AS SELECT main.one.a, one.b, c FROM "t xx" AS one}}
188 CREATE VIEW v AS SELECT one.a, one.b, t2.a, t2.b FROM t1 AS one, t2;
485 CREATE VIEW y AS SELECT f1 AS f1 FROM x;
506 } {{CREATE VIEW y AS SELECT f2 AS f1 FROM x}}
620 CREATE VIEW t2 AS SELECT 1 FROM t1, (t1 AS a0, t1);
646 CREATE VIEW c AS
803 CREATE VIEW v0 AS
915 SELECT * FROM c1 AS x1, c2 AS x2, (
945 SELECT * FROM c1 AS x1, c2 AS x2, (
[all …]
H A Dview3.test31 CREATE VIEW v1 AS SELECT x*2 FROM t1;
32 CREATE VIEW v2 AS SELECT * FROM v1 UNION SELECT * FROM v1;
33 CREATE VIEW v4 AS SELECT * FROM v2 UNION SELECT * FROM v2;
34 CREATE VIEW v8 AS SELECT * FROM v4 UNION SELECT * FROM v4;
35 CREATE VIEW v16 AS SELECT * FROM v8 UNION SELECT * FROM v8;
36 CREATE VIEW v32 AS SELECT * FROM v16 UNION SELECT * FROM v16;
37 CREATE VIEW v64 AS SELECT * FROM v32 UNION SELECT * FROM v32;
38 CREATE VIEW v128 AS SELECT * FROM v64 UNION SELECT * FROM v64;
39 CREATE VIEW v256 AS SELECT * FROM v128 UNION SELECT * FROM v128;
40 CREATE VIEW v512 AS SELECT * FROM v256 UNION SELECT * FROM v256;
[all …]
H A Dunionall.test28 CREATE VIEW t1 AS
93 WITH s(i) AS (
104 WITH s(i) AS (
114 CREATE VIEW t2 AS
142 SELECT x1.*, x2.* FROM t2 AS x1, t2 AS x2 WHERE x1.k=x2.k+1
229 CREATE VIEW t3 AS
246 CREATE VIEW t1 AS
367 WITH x(c) AS (
370 y(d) AS (
384 FROM c1 AS x1, (SELECT x+1 AS y FROM c1 WHERE x<1 UNION ALL SELECT 1+x FROM c1 WHERE 1<x) AS x2
[all …]
H A Dcolname.test22 # (1) If there is an AS clause, use it.
57 CREATE VIEW v1 AS SELECT tabC.a, txyZ.x, *
78 SELECT +tabc.a AS AAA, -tabc.b AS BBB, tabc.c CCC, * FROM tabc
135 SELECT +tabc.a AS AAA, -tabc.b AS BBB, tabc.c CCC FROM tabc
201 SELECT +tabc.a AS AAA, -tabc.b AS BBB, tabc.c CCC FROM tabc
278 execsql2 {SELECT a, max(a) AS m FROM t6}
281 execsql2 {SELECT `a`, max(a) AS m FROM t6}
370 CREATE VIEW v3 AS SELECT c AS a, d AS b FROM t2;
398 CREATE TABLE t2 AS SELECT BBb FROM (SELECT aaa AS Bbb FROM t1);
416 CREATE TABLE t4 AS SELECT #0;
[all …]
H A Dwindow1.test395 WINDOW w1 AS (
482 WINDOW win AS (
499 WINDOW win AS (
655 ) AS y FROM t2
665 SELECT CAST(1 AS INT), CAST(NULL AS INT)
676 ), q AS (
706 WITH c AS(
1153 WINDOW w1 AS
1186 WINDOW w1 AS
1437 WINDOW win3 AS (
[all …]
H A Dtkt-a7b7803e.test25 SELECT (t1.a==0) AS x, b
32 SELECT a, (t1.b='fuzzy') AS x
39 SELECT (a=99) AS x, (t1.b='fuzzy') AS y, *
46 SELECT (a=99) AS x, (t1.b='first') AS y, *
54 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b
62 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b
70 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b
77 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b
H A Dwindow6.test73 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)
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)
190 SELECT "counter", "value", RANK() OVER w AS "rank"
192 WINDOW w AS (PARTITION BY "counter" ORDER BY "value" DESC)
283 WITH t1(a,b) AS (VALUES(1,2))
286 WINDOW w1 AS (ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING);
297 WITH t1(a,b) AS ( VALUES(1, 2), (2, 3), (3, 4) )
311 WITH t1(a,b) AS ( VALUES(1, 2), (2, 3), (3, 4) )
[all …]
H A Doptfuzz-db01.txt102 CREATE VIEW v12(a,b,c,d,e) AS
104 CREATE VIEW v22(a,b,c,d,e) AS
107 CREATE VIEW v32(a,b,c,d,e) AS
110 CREATE VIEW v42(a,b,c,d,e) AS
113 CREATE VIEW v52(a,b,c,d,e) AS
117 CREATE VIEW v13(a,b,c,d,e) AS
121 CREATE VIEW v23(a,b,c,d,e) AS
125 CREATE VIEW v60(a,b,c,d,e) AS
128 CREATE VIEW v61(a,b,c,d,e) AS
131 CREATE VIEW v62(a,b,c,d,e) AS
[all …]
H A Dtkt-7bbfb7d442.test83 T1.SKU AS SKU,
84 T1.Variant AS Variant,
85 T1.ControlDate AS ControlDate,
86 1 AS ControlState,
87 COALESCE(T2.DeliveredQty,0) AS DeliveredQty
91 II.SKU AS SKU,
92 II.Variant AS Variant,
105 TD.SKU AS SKU,
106 TD.Variant AS Variant,
107 10 AS DeliveredQty
[all …]
H A Djoin.test98 SELECT aaa.*, bbb.* FROM t2 AS aaa NATURAL JOIN t1 AS bbb
125 SELECT * FROM t1 AS x INNER JOIN t2 AS y USING(b,c);
750 FROM (SELECT 1 a) AS x
809 CREATE VIEW v2 AS SELECT a, 1 AS b FROM t1;
890 LEFT JOIN (SELECT a AS a2, b AS b2 FROM t1)
894 LEFT JOIN (SELECT a AS a3, b AS b3 FROM t1)
898 LEFT JOIN (SELECT a AS a4, b AS b4 FROM t1)
902 LEFT JOIN (SELECT a AS a5, b AS b5 FROM t1)
1137 WITH t99(b) AS (
1145 JOIN (SELECT coalesce(b,3) AS b2 FROM t2 AS x LEFT JOIN t1
[all …]
H A Dmisc2.test79 SELECT * FROM (SELECT a, b AS 'a', c AS 'a', 4 AS 'a' FROM t1)
138 CREATE VIEW y AS
139 SELECT x1.b AS p, x2.b AS q FROM x AS x1, x AS x2 WHERE x1.a=x2.a;
140 CREATE VIEW z AS
141 SELECT y1.p, y2.p FROM y AS y1, y AS y2 WHERE y1.q=y2.q;
393 CREATE TEMP TABLE x AS
395 FROM counts AS dim1, counts AS dim2, counts AS dim3
404 CREATE TEMP TABLE x AS
406 FROM counts AS dim1, counts AS dim2, counts AS dim3
415 CREATE TEMP TABLE x AS
[all …]

12345678910>>...24