Home
last modified time | relevance | path

Searched refs:VIEW (Results 1 – 25 of 171) sorted by relevance

1234567

/sqlite-3.40.0/test/
H A Dview.test186 DROP VIEW v1;
226 CREATE VIEW v4 AS
239 DROP VIEW t1;
275 CREATE VIEW v5 AS
340 CREATE VIEW test AS
355 DROP VIEW test;
356 CREATE VIEW test AS
371 DROP VIEW test;
372 CREATE VIEW test AS
448 CREATE VIEW v9 AS
[all …]
H A De_dropview.test29 CREATE VIEW v1 AS SELECT * FROM t1;
30 CREATE VIEW v2 AS SELECT * FROM t1;
34 CREATE VIEW temp.v1 AS SELECT * FROM t1;
38 CREATE VIEW aux.v1 AS SELECT * FROM t1;
39 CREATE VIEW aux.v2 AS SELECT * FROM t1;
40 CREATE VIEW aux.v3 AS SELECT * FROM t1;
93 # created by the CREATE VIEW statement.
107 DROP VIEW "new view";
132 do_execsql_test 3.2.1 { DROP VIEW v1 } {}
138 do_execsql_test 3.3.1 { DROP VIEW v2 } {}
[all …]
H A Dview3.test12 # focus of this file is testing VIEW statements.
31 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;
[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 Dexists.test60 # VIEW objects.
63 sql2 { CREATE VIEW v1 AS SELECT * FROM t1 }
65 sql2 { DROP VIEW v1 }
105 # VIEW objects.
108 sql1 { DROP VIEW IF EXISTS v1 }
110 sql1 { DROP VIEW IF EXISTS v1 }
166 # VIEW objects.
169 sql1 { DROP VIEW IF EXISTS aux.v1 }
171 sql1 { DROP VIEW IF EXISTS aux.v1 }
175 sql1 { DROP VIEW IF EXISTS v1 }
[all …]
H A Daltertab.test201 DROP VIEW v;
285 DROP VIEW v1;
646 CREATE VIEW c AS
803 CREATE VIEW v0 AS
819 } {{CREATE VIEW v0 AS
825 CREATE VIEW v2 AS
845 } {{CREATE VIEW v2 AS
864 CREATE VIEW v3 AS
889 } {{CREATE VIEW v3 AS
903 CREATE VIEW v1(x,y) AS
[all …]
H A Dalterqf.test36 1 {CREATE VIEW v1 AS SELECT "a", "b", "notacolumn!", "c" FROM t1}
37 {CREATE VIEW v1 AS SELECT "a", "b", 'notacolumn!', "c" FROM t1}
39 2 {CREATE VIEW v1 AS SELECT "a", "b", "not'a'column!", "c" FROM t1}
40 {CREATE VIEW v1 AS SELECT "a", "b", 'not''a''column!', "c" FROM t1}
42 3 {CREATE VIEW v1 AS SELECT "a", "b", "not""a""column!", "c" FROM t1}
43 {CREATE VIEW v1 AS SELECT "a", "b", 'not"a"column!', "c" FROM t1}
45 4 {CREATE VIEW v1 AS SELECT "val", count("b") FROM t1 GROUP BY "abc"}
46 {CREATE VIEW v1 AS SELECT 'val', count("b") FROM t1 GROUP BY 'abc'}
57 8 {CREATE VIEW v1 AS SELECT "string"'alias' FROM t1}
58 {CREATE VIEW v1 AS SELECT 'string' 'alias' FROM t1}
H A Dtkt1644.test34 CREATE TEMP VIEW v1 AS SELECT * FROM t1;
45 DROP VIEW v1;
46 CREATE TEMP VIEW v1 AS SELECT * FROM t2;
87 CREATE TEMP VIEW temp_v1 AS SELECT * FROM real_t1;
92 DROP VIEW temp_v1;
99 CREATE TEMP VIEW temp_v1 AS SELECT * FROM real_t1 LIMIT 10 OFFSET 10;
104 DROP VIEW temp_v1;
H A Daltercol.test281 CREATE VIEW v1 AS SELECT x, y, z FROM a1;
287 } {{CREATE VIEW v1 AS SELECT x, yyy, z FROM a1}}
290 DROP VIEW v1;
302 DROP VIEW v2;
342 CREATE VIEW zzz AS SELECT george, ringo FROM b1;
483 # 2. Renaming a column of a VIEW,
503 CREATE VIEW v1 AS SELECT * FROM t1;
504 CREATE VIEW v2(c, d) AS SELECT * FROM t1;
681 CREATE VIEW v4 AS SELECT a, d FROM t1, t2;
719 CREATE VIEW temp.v5 AS SELECT "big c" FROM t1;
[all …]
H A Djoin7.test26 CREATE VIEW dual(dummy) AS VALUES('x');
35 CREATE VIEW dual(dummy) AS VALUES('x');
44 CREATE VIEW dual(dummy) AS VALUES('x');
51 CREATE VIEW dual(dummy) AS VALUES('x');
58 CREATE VIEW dual(dummy) AS VALUES('x');
63 CREATE VIEW t2(c,d) AS VALUES(3,33),(4,44),(5,55);
64 CREATE VIEW dual(dummy) AS VALUES('x');
67 CREATE VIEW t1(a,b) AS VALUES(1,2),(1,3),(1,4);
70 CREATE VIEW dual(dummy) AS VALUES('x');
77 CREATE VIEW dual(dummy) AS VALUES('x');
[all …]
H A Djoin9.test24 CREATE VIEW dual(dummy) AS VALUES('x');
49 CREATE VIEW dual(dummy) AS VALUES('x');
55 CREATE VIEW t3 AS SELECT * FROM t3x LIMIT 1000;
56 CREATE VIEW t4 AS SELECT * FROM t4x LIMIT 1000;
57 CREATE VIEW t5 AS SELECT * FROM t5x LIMIT 1000;
58 CREATE VIEW t6 AS SELECT * FROM t6x LIMIT 1000;
69 CREATE VIEW dual(dummy) AS VALUES('x');
78 CREATE VIEW t3 AS SELECT * FROM t3a UNION ALL SELECT * FROM t3b;
79 CREATE VIEW t4 AS SELECT * FROM t4a UNION ALL SELECT * FROM t4b;
80 CREATE VIEW t5 AS SELECT * FROM t5a UNION ALL SELECT * FROM t5b;
[all …]
H A Dalterlegacy.test105 CREATE VIEW vvv AS SELECT main.txx.a, txx.b, c FROM txx;
106 CREATE VIEW uuu AS SELECT main.one.a, one.b, c FROM txx AS one;
121 } {{CREATE VIEW vvv AS SELECT main.txx.a, txx.b, c FROM txx}}
129 } {{CREATE VIEW uuu AS SELECT main.one.a, one.b, c FROM txx AS one}}
136 } {{CREATE VIEW ttt AS SELECT main.txx.a, txx.b, one.b, main.one.a FROM txx AS one, txx}}
204 CREATE VIEW v AS SELECT one.a, one.b, t2.a, t2.b FROM t1 AS one, t2;
218 DROP VIEW v;
219 CREATE VIEW temp.vv AS SELECT one.a, one.b, t2.a, t2.b FROM t1 AS one, t2;
293 CREATE VIEW v1 AS SELECT * FROM t2;
302 DROP VIEW v1;
[all …]
H A Dtkt-a7debbe0.test32 CREATE VIEW v2(a, B) AS
36 CREATE VIEW v3(a, B) AS
39 CREATE VIEW v4(a, B) AS
42 CREATE VIEW v5(a, B) AS
84 DROP VIEW v2;
88 CREATE VIEW v2(c0, c1) AS
H A Daffinity3.test28 CREATE VIEW v1 AS
33 CREATE VIEW v1rj AS
38 CREATE VIEW v2 AS
43 CREATE VIEW v2rj AS
47 CREATE VIEW v2rjrj AS
101 CREATE VIEW idmap as
H A Dview2.test12 # focus of this file is testing VIEW statements.
28 CREATE VIEW v1 AS SELECT * FROM (
39 CREATE VIEW v3 AS SELECT * FROM main.t1;
45 CREATE VIEW v2 AS SELECT * FROM t1;
H A Dtkt1444.test25 # The use of a VIEW that contained an ORDER BY clause within a UNION ALL
34 CREATE VIEW DemoView AS SELECT * FROM DemoTable ORDER BY TextKey;
45 DROP VIEW DemoView;
46 CREATE VIEW DemoView AS SELECT * FROM DemoTable;
H A Daltertab3.test73 CREATE VIEW v1 AS SELECT * FROM t1 WHERE a=1 OR (b IN ());
226 CREATE VIEW v1 AS SELECT * FROM t1 WHERE (
235 {CREATE VIEW v1 AS SELECT * FROM t1 WHERE (
422 CREATE VIEW q AS SELECT 123
433 CREATE VIEW q AS SELECT
459 DROP VIEW IF EXISTS q;
483 CREATE VIEW v AS SELECT (
495 CREATE VIEW v2(b) AS SELECT * FROM v2;
503 DROP VIEW v2;
512 DROP VIEW v2;
[all …]
H A Dtrigger9.test153 CREATE VIEW v1 AS SELECT * FROM t3;
170 CREATE VIEW v1 AS SELECT a, b AS c FROM t3 WHERE c > 'one';
184 CREATE VIEW v1 AS SELECT DISTINCT a, b FROM t3;
199 CREATE VIEW v1 AS SELECT a, b FROM t3 EXCEPT SELECT 1, 'one';
212 CREATE VIEW v1 AS
230 CREATE VIEW v1 AS SELECT a, b FROM t1;
H A Dunionall.test28 CREATE VIEW t1 AS
72 CREATE VIEW t1 AS SELECT a, b FROM t1_a UNION ALL SELECT c, c FROM t1_b;
114 CREATE VIEW t2 AS
229 CREATE VIEW t3 AS
246 CREATE VIEW t1 AS
255 CREATE VIEW t3 AS
330 CREATE VIEW t1 AS
334 CREATE VIEW t3 AS
406 CREATE VIEW v0(c0) AS SELECT CAST(t0.c0 AS INTEGER) FROM t0;
407 CREATE VIEW t1 AS
H A Dtrustschema1.test179 CREATE VIEW v1a AS SELECT f3(a+b) FROM t1;
191 DROP VIEW v1a;
192 CREATE TEMP VIEW v1a AS SELECT f3(a+b) FROM t1;
196 CREATE VIEW v1b AS SELECT f2(b+c) FROM t1;
208 DROP VIEW v1b;
209 CREATE TEMP VIEW v1b AS SELECT f2(b+c) FROM t1;
H A DtriggerA.test12 # it tests issues relating to firing an INSTEAD OF trigger on a VIEW
52 CREATE VIEW v1 AS SELECT y, x FROM t1;
58 CREATE VIEW v2 AS SELECT x, y FROM t1 WHERE y GLOB '*e*';
64 CREATE VIEW v3 AS
71 CREATE VIEW v4 AS
79 CREATE VIEW v5 AS SELECT x, b FROM t1, t2 WHERE y=c;
H A Dunionall2.test23 CREATE VIEW v1 AS SELECT * FROM t1, t2;
24 CREATE VIEW v2 AS SELECT * FROM t1, t2;
26 CREATE VIEW vA AS
H A DwindowD.test20 CREATE VIEW v0(c0, c1)
61 CREATE VIEW v1(a, b, c, d) AS SELECT 1, 2, TRUE, FALSE FROM t1;
77 CREATE VIEW v2 AS SELECT max(x) OVER () AS a, TRUE AS c FROM t1;
H A Dwith4.test32 CREATE VIEW v1 AS SELECT * FROM t1, aux.t2;
35 CREATE VIEW v2 AS WITH v(m,n) AS (SELECT x,y FROM aux.t2) SELECT * FROM t1, v;
38 CREATE VIEW v2 AS WITH v(m,n) AS (SELECT 5,?2) SELECT * FROM t1, v;
H A Dcolname.test57 CREATE VIEW v1 AS SELECT tabC.a, txyZ.x, *
59 CREATE VIEW v2 AS SELECT tabC.a, txyZ.x, tboTh.a, tbotH.x, *
114 CREATE VIEW v3 AS SELECT tabC.a, txyZ.x, *
116 CREATE VIEW v4 AS SELECT tabC.a, txyZ.x, tboTh.a, tbotH.x, *
180 CREATE VIEW v5 AS SELECT tabC.a, txyZ.x, *
182 CREATE VIEW v6 AS SELECT tabC.a, txyZ.x, tboTh.a, tbotH.x, *
345 CREATE VIEW v1(x,y) AS SELECT a,b FROM t1;
355 CREATE VIEW v2(x,y) AS SELECT a,b FROM t1 LIMIT 10;
370 CREATE VIEW v3 AS SELECT c AS a, d AS b FROM t2;

1234567