Home
last modified time | relevance | path

Searched refs:v4 (Results 1 – 16 of 16) sorted by relevance

/sqlite-3.40.0/test/
H A Dcolname.test116 CREATE VIEW v4 AS SELECT tabC.a, txyZ.x, tboTh.a, tbotH.x, *
170 SELECT * FROM v4 ORDER BY 2;
236 SELECT * FROM v4 ORDER BY 2;
238 } {v4.a 1 v4.x 4 v4.a:1 11 v4.x:1 14 v4.a:2 1 v4.b 2 v4.c 3 v4.x:2 4 v4.y 5 v4.z 6 v4.a:3 11 v4.b:1…
H A Dsort.test296 CREATE VIEW v4 AS SELECT * FROM t4;
297 SELECT a FROM v4 ORDER BY 1;
302 SELECT b FROM v4 ORDER BY 1;
309 SELECT a FROM t4 UNION SELECT a FROM v4 ORDER BY 1;
314 SELECT b FROM t4 UNION SELECT a FROM v4 ORDER BY 1;
316 } {1 2 11 12 1 11 12 2} ;# text from t4.b and numeric from v4.a
319 SELECT a FROM t4 UNION SELECT b FROM v4 ORDER BY 1;
321 } {1 2 11 12 1 11 12 2} ;# numeric from t4.a and text from v4.b
324 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1;
343 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE text;
[all …]
H A DtriggerA.test71 CREATE VIEW v4 AS
74 SELECT * FROM v4 ORDER BY 1;
156 CREATE TRIGGER r4d INSTEAD OF DELETE ON v4 BEGIN
159 DELETE FROM v4 WHERE c1 BETWEEN '8' AND 'eight';
166 CREATE TRIGGER r4u INSTEAD OF UPDATE ON v4 BEGIN
169 UPDATE v4 SET c1 = c1 || '-extra' WHERE c1 BETWEEN '8' and 'eight';
H A Din6.test94 CREATE TABLE v3(v5, v4);
96 CREATE INDEX v9 ON v3(v4, v4, v5);
97 SELECT quote(v5) FROM v0 LEFT JOIN v3 ON v4 = NULL AND v5 IN(0);
H A Dview3.test33 CREATE VIEW v4 AS SELECT * FROM v2 UNION SELECT * FROM v2;
34 CREATE VIEW v8 AS SELECT * FROM v4 UNION SELECT * FROM v4;
H A Dtkt-a7debbe0.test39 CREATE VIEW v4(a, B) AS
51 do_execsql_test $tn.1.1.5 { SELECT a >= B FROM v4 } 1
58 do_execsql_test $tn.1.2.5 { SELECT a < B FROM v4 } 0
H A DwhereL.test23 CREATE VIEW v4 AS SELECT * FROM t2 UNION ALL SELECT * FROM t3;
26 SELECT * FROM t1, v4 WHERE t1.a=?1 AND v4.a=t1.a;
H A Dindex7.test316 CREATE VIEW v4 AS SELECT * FROM t4;
318 SELECT * FROM v4 WHERE d='xyz' AND c='def'
323 SELECT * FROM v4 WHERE d='xyz' AND c='def'
H A Daltertab2.test343 CREATE VIEW v4 AS SELECT * FROM t4 WHERE (a=1 AND 0) OR b=2;
351 SELECT sql FROM sqlite_master WHERE name = 'v4'
352 } {{CREATE VIEW v4 AS SELECT * FROM t4 WHERE (c=1 AND 0) OR b=2}}
H A Daltercol.test681 CREATE VIEW v4 AS SELECT a, d FROM t1, t2;
682 SELECT * FROM v4;
687 } {1 {error in view v4 after rename: ambiguous column name: a}}
690 SELECT * FROM v4;
H A Dview.test226 CREATE VIEW v4 AS
231 SELECT b FROM v4 ORDER BY b LIMIT 4;
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5connect.test197 CREATE VIEW v4 AS SELECT rowid, * FROM ft4;
199 CREATE TRIGGER t4_ai INSTEAD OF INSERT ON v4 BEGIN
204 CREATE TRIGGER t4_ad INSTEAD OF DELETE ON v4 BEGIN
209 CREATE TRIGGER t4_au INSTEAD OF UPDATE ON v4 BEGIN
220 2 "REPLACE INTO v4(rowid, a, b) VALUES(1, 'five', 'six')" {}
222 4 "INSERT INTO v4(rowid, a, b) VALUES(3, 'seven', 'eight')" {}
224 6 "DELETE FROM v4 WHERE rowid=2" {}
225 7 "UPDATE v4 SET b='nine' WHERE rowid=1" {}
/sqlite-3.40.0/tool/
H A DGetTclKit.bat133 ) ELSE IF EXIST "%windir%\Microsoft.NET\Framework64\v4.0.30319" (
134 SET FRAMEWORKDIR=%windir%\Microsoft.NET\Framework64\v4.0.30319
139 ) ELSE IF EXIST "%windir%\Microsoft.NET\Framework\v4.0.30319" (
140 SET FRAMEWORKDIR=%windir%\Microsoft.NET\Framework\v4.0.30319
/sqlite-3.40.0/ext/wasm/api/
H A Dsqlite3-wasm.c325 int v4; member
335 s->v4 *= 2; in sqlite3_wasm_test_struct()
336 s->v8 = s->v4 * 2; in sqlite3_wasm_test_struct()
786 M(v4,"i"); in sqlite3_wasm_enum_json()
/sqlite-3.40.0/
H A Dconfig.sub1329 # Don't forget version if it is 3.2v4 or newer.
/sqlite-3.40.0/ext/wasm/jaccwabyt/
H A Djaccwabyt.md930 int v4;
992 M(v4,"i");