Home
last modified time | relevance | path

Searched refs:v1 (Results 1 – 25 of 127) sorted by relevance

123456

/sqlite-3.40.0/test/
H A De_dropview.test82 1 "DROP VIEW v1" {main.v1 main.v2 aux.v1 aux.v2 aux.v3}
83 2 "DROP VIEW v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3}
84 3 "DROP VIEW main.v1" {main.v2 temp.v1 aux.v1 aux.v2 aux.v3}
85 4 "DROP VIEW main.v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3}
86 5 "DROP VIEW IF EXISTS v1" {main.v1 main.v2 aux.v1 aux.v2 aux.v3}
87 6 "DROP VIEW IF EXISTS v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3}
88 7 "DROP VIEW IF EXISTS main.v1" {main.v2 temp.v1 aux.v1 aux.v2 aux.v3}
89 8 "DROP VIEW IF EXISTS main.v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3}
182 #expr {[list_all_views] == "main.v1 main.v2 temp.v1 aux.v1 aux.v2 aux.v3"}
184 1 "DROP VIEW IF EXISTS xx" "main.v1 main.v2 temp.v1 aux.v1 aux.v2 aux.v3"
[all …]
H A Dtkt3298.test29 CREATE TRIGGER r1 INSTEAD OF UPDATE ON v1
33 CREATE TRIGGER r2 INSTEAD OF DELETE ON v1
37 SELECT * FROM v1 ORDER BY x;
42 UPDATE v1 SET y=3 WHERE x=0;
43 SELECT * FROM v1 ORDER by x;
48 UPDATE v1 SET y=4 WHERE v1.x=2;
49 SELECT * FROM v1 ORDER by x;
54 DELETE FROM v1 WHERE x=1;
55 SELECT * FROM v1 ORDER BY x;
60 DELETE FROM v1 WHERE v1.x=2;
[all …]
H A Dtrigger9.test153 CREATE VIEW v1 AS SELECT * FROM t3;
157 UPDATE v1 SET b = 'hello';
174 UPDATE v1 SET c = 'hello';
188 UPDATE v1 SET b = 'hello';
203 UPDATE v1 SET b = 'hello';
212 CREATE VIEW v1 AS
217 UPDATE v1 SET b = 'hello';
230 CREATE VIEW v1 AS SELECT a, b FROM t1;
232 CREATE TRIGGER tr1 INSTEAD OF DELETE ON v1 BEGIN
246 DELETE FROM v1 WHERE rowid=1;
[all …]
H A Djoin2.test161 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
164 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
168 SELECT DISTINCT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
172 SELECT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
176 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
184 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
208 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
211 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
215 SELECT DISTINCT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
219 SELECT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
[all …]
H A Dview.test38 SELECT * FROM v1 ORDER BY a;
44 SELECT * FROM v1 ORDER BY a;
61 } {v1 view}
68 } {1 {no such table: v1}}
84 DROP VIEW IF EXISTS v1;
87 } {1 {no such table: v1}}
176 SELECT * FROM v1 LIMIT 1
186 DROP VIEW v1;
188 SELECT * FROM v1 LIMIT 1
249 DROP TABLE v1;
[all …]
H A Dshared8.test59 CREATE VIEW v1 AS SELECT a, roman(b) FROM t1;
60 SELECT * FROM v1;
75 execsql { SELECT * FROM v1 } db1
81 execsql { SELECT * FROM v1 } db2
86 execsql { SELECT * FROM v1 } db2
92 execsql { SELECT * FROM v1 } db3
96 execsql { SELECT * FROM v1 } db2
101 execsql { SELECT * FROM v1 } db3
107 catchsql { SELECT * FROM v1 } db4
108 } {1 {no such table: v1}}
H A Dexists.test63 sql2 { CREATE VIEW v1 AS SELECT * FROM t1 }
65 sql2 { DROP VIEW v1 }
68 } {v1}
108 sql1 { DROP VIEW IF EXISTS v1 }
109 sql2 { CREATE VIEW v1 AS SELECT * FROM t2 }
110 sql1 { DROP VIEW IF EXISTS v1 }
169 sql1 { DROP VIEW IF EXISTS aux.v1 }
170 sql2 { CREATE VIEW aux.v1 AS SELECT * FROM t2 }
171 sql1 { DROP VIEW IF EXISTS aux.v1 }
175 sql1 { DROP VIEW IF EXISTS v1 }
[all …]
H A Dcolmeta.test36 CREATE VIEW v1 AS SELECT * FROM abc2;
74 200 {{} v1 a} {1 {no such table column: v1.a}}
75 201 {main v1 b} {1 {no such table column: v1.b}}
76 202 {main v1 badname} {1 {no such table column: v1.badname}}
77 203 {main v1 rowid} {1 {no such table column: v1.rowid}}
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 Daffinity3.test28 CREATE VIEW v1 AS
39 SELECT c.id, v1.apr
41 LEFT JOIN v1 ON v1.id=c.id;
44 SELECT c.id, v1.apr
45 FROM v1 RIGHT JOIN customer c ON v1.id=c.id;
58 SELECT id, (apr / 100), typeof(apr) apr_type FROM v1;
75 SELECT id, (apr / 100), typeof(apr) apr_type FROM v1;
H A Dhidden.test39 1 { CREATE VIEW v1(a, b, __hidden__c) AS SELECT a, b, c FROM x1 }
40 2 { CREATE VIEW v1 AS SELECT a, b, c AS __hidden__c FROM x1 }
48 catchsql { DROP VIEW v1 }
52 SELECT a, b, __hidden__c FROM v1;
56 SELECT * FROM v1;
60 CREATE TRIGGER tr1 INSTEAD OF INSERT ON v1 BEGIN
64 INSERT INTO v1 VALUES(4, 5);
69 INSERT INTO v1(a, b, __hidden__c) VALUES(7, 8, 9);
H A Dcolname.test57 CREATE VIEW v1 AS SELECT tabC.a, txyZ.x, *
98 SELECT * FROM v1 ORDER BY 2;
155 SELECT v1.a, * FROM v1 ORDER BY 2;
157 } {v1.a 1 a 1 x 4 a:1 1 b 2 c 3 x:1 4 y 5 z 6}
221 SELECT * FROM v1 ORDER BY 2;
223 } {v1.a 1 v1.x 4 v1.a:1 1 v1.b 2 v1.c 3 v1.x:1 4 v1.y 5 v1.z 6}
345 CREATE VIEW v1(x,y) AS SELECT a,b FROM t1;
347 execsql2 {SELECT v1.x, (Y) FROM v1}
348 # Prior to the fix, this would return: "v1.x 1 (Y) 2"
351 execsql2 {SELECT * FROM v1}
H A Dauth.test598 } {v1 {} main {}}
798 } {t1 v1}
814 } {t1 v1}
826 } {t1 v1}
842 } {t1 v1}
2432 SQLITE_READ v1 x main v1 \
2433 SQLITE_READ v1 x main v1 \
2435 SQLITE_READ v1 x main v1 \
2460 SQLITE_READ v1 x main v1 \
2461 SQLITE_READ v1 x main v1 \
[all …]
H A Dtkt1644.test34 CREATE TEMP VIEW v1 AS SELECT * FROM t1;
35 SELECT * FROM v1;
39 # The "SELECT * FROM v1" should be in the TCL interface cache below.
45 DROP VIEW v1;
46 CREATE TEMP VIEW v1 AS SELECT * FROM t2;
47 SELECT * FROM v1;
H A Dtkt2192.test99 CREATE VIEW v1 AS
115 SELECT b FROM v1 ORDER BY b;
120 SELECT * FROM v1 ORDER BY a, b;
126 FROM v1 AS x JOIN v1 AS y ON x.a=y.a AND x.b<y.b
134 FROM v1 AS x JOIN v1 AS y ON x.a=y.a AND x.b<y.b
H A Dregexp1.test190 set v1 "abc\ndef"
191 db eval {SELECT $v1 REGEXP '^abc\ndef$'}
194 set v1 "abc\adef"
195 db eval {SELECT $v1 REGEXP '^abc\adef$'}
198 set v1 "abc\tdef"
199 db eval {SELECT $v1 REGEXP '^abc\tdef$'}
202 set v1 "abc\rdef"
203 db eval {SELECT $v1 REGEXP '^abc\rdef$'}
206 set v1 "abc\fdef"
207 db eval {SELECT $v1 REGEXP '^abc\fdef$'}
[all …]
H A Dtriggerupfrom.test132 CREATE VIEW v1 AS SELECT k, a, b AS __hidden__b FROM t1;
133 CREATE TRIGGER tr1 INSTEAD OF UPDATE ON v1 BEGIN
142 SELECT * FROM v1
146 SELECT * FROM v1
151 UPDATE v1 SET a='xyz' WHERE k IN ('a', 'c');
163 UPDATE v1 SET a=map.v FROM map WHERE v1.k=map.k;
H A Dwherelfault.test35 CREATE VIEW v1 AS SELECT a,b FROM t1;
38 CREATE TRIGGER v1del INSTEAD OF DELETE ON v1 BEGIN
42 CREATE TRIGGER v1upd INSTEAD OF UPDATE ON v1 BEGIN
52 execsql { DELETE FROM v1 ORDER BY a LIMIT 3; }
61 execsql { UPDATE v1 SET b = 555 ORDER BY a LIMIT 3 }
H A Dattach3.test137 CREATE VIEW aux.v1 AS SELECT * FROM t3;
142 SELECT * FROM aux.sqlite_master WHERE name = 'v1';
144 } {view v1 v1 0 {CREATE VIEW v1 AS SELECT * FROM t3}}
148 SELECT * FROM v1;
155 DROP VIEW aux.v1;
160 SELECT * FROM aux.sqlite_master WHERE name = 'v1';
H A DwindowD.test61 CREATE VIEW v1(a, b, c, d) AS SELECT 1, 2, TRUE, FALSE FROM t1;
65 SELECT 500 IS a, 500 IS b, 500 IS c, 500 IS d FROM v1
69 SELECT * FROM v1 WHERE 500 IS c;
73 SELECT * FROM v1 WHERE 500 IS d;
H A Dalterdropcol.test25 CREATE VIEW v1 AS SELECT * FROM t1;
39 ALTER TABLE v1 DROP COLUMN c;
40 } {1 {cannot drop column from view "v1"}}
227 CREATE VIEW v1 AS SELECT d, e FROM p1
231 } {1 {error in view v1: no such column: d}}
233 DROP VIEW v1;
234 CREATE VIEW v1 AS SELECT x, y FROM c1;
238 } {1 {error in view v1 after drop column: no such column: x}}
H A De_totalchanges.test196 CREATE VIEW v1 AS SELECT * FROM t6;
197 CREATE TRIGGER v1_tr1 INSTEAD OF INSERT ON v1 BEGIN
201 INSERT INTO v1 VALUES('a');
202 INSERT INTO v1 VALUES('b');
205 CREATE TRIGGER v1_tr2 INSTEAD OF INSERT ON v1 BEGIN
209 INSERT INTO v1 VALUES('c');
210 INSERT INTO v1 VALUES('d');
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5vocab2.test33 SELECT * FROM v1;
57 SELECT * FROM v1;
69 SELECT * FROM v1;
82 SELECT * FROM v1;
99 SELECT * FROM v1;
121 SELECT * FROM v1;
133 SELECT * FROM v1;
144 SELECT * FROM v1;
161 SELECT * FROM v1;
181 SELECT * FROM v1;
[all …]
/sqlite-3.40.0/ext/rbu/
H A Drbuvacuum2.test141 CREATE VIEW v1 AS SELECT * FROM t1;
149 view v1 v1 0 {CREATE VIEW v1 AS SELECT * FROM t1}
158 view v1 v1 0 {CREATE VIEW v1 AS SELECT * FROM t1}
/sqlite-3.40.0/ext/misc/
H A Dpercentile.c185 double v1, v2; in percentFinal() local
195 v1 = p->a[i1]; in percentFinal()
197 vx = v1 + (v2-v1)*(ix-i1); in percentFinal()

123456