Home
last modified time | relevance | path

Searched refs:v2 (Results 1 – 25 of 78) sorted by relevance

1234

/sqlite-3.40.0/test/
H A DcorruptM.test45 } {table t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
50 } {table t1 {} | index i1 t1 | view v2 v2 | trigger r1 t1 |}
60 } {table t1 tx | index i1 t1 | view v2 v2 | trigger r1 t1 |}
69 } {tabl t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
78 } {table t9 t9 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
88 } {table t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
99 } {view t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
111 } {table t1 t1 | index i1 tx | view v2 v2 | trigger r1 t1 |}
133 } {table t1 t1 | view i1 t1 | view v2 v2 | trigger r1 t1 |}
168 } {table t1 t1 | index i1 t1 | view v2 v2 | view r1 t1 |}
[all …]
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}
134 do_test 3.2.3 { list_all_views } {main.v2 aux.v1 aux.v2 aux.v3}
171 3 "DROP VIEW temp.v2" temp.v2
[all …]
H A Dauth2.test120 SELECT a, b FROM v2;
124 SQLITE_READ t2 x main v2
125 SQLITE_READ t2 y main v2
126 SQLITE_READ t2 y main v2
127 SQLITE_READ t2 z main v2
128 SQLITE_READ v2 a main {}
129 SQLITE_READ v2 b main {}
138 SELECT b, a FROM v2;
142 SQLITE_READ t2 x main v2
143 SQLITE_READ t2 y main v2
[all …]
H A Dtkt-a7debbe0.test32 CREATE VIEW v2(a, B) AS
46 # Table t2 and views v2 through v5 should all be equivalent.
49 do_execsql_test $tn.1.1.3 { SELECT a >= B FROM v2 } 1
56 do_execsql_test $tn.1.2.3 { SELECT B < a FROM v2 } 0
84 DROP VIEW v2;
88 CREATE VIEW v2(c0, c1) AS
91 SELECT v2.c1 BETWEEN v2.c0 AND v2.c1 as count FROM v2
96 # of v2.c1 - BINARY.
98 SELECT v2.c1 BETWEEN v2.c0 AND v2.c1 as count FROM v2;
H A Dcolname.test59 CREATE VIEW v2 AS SELECT tabC.a, txyZ.x, tboTh.a, tbotH.x, *
103 SELECT * FROM v2 ORDER BY 2;
160 SELECT * FROM v2 ORDER BY 2;
226 SELECT * FROM v2 ORDER BY 2;
228 } {v2.a 1 v2.x 4 v2.a:1 11 v2.x:1 14 v2.a:2 1 v2.b 2 v2.c 3 v2.x:2 4 v2.y 5 v2.z 6 v2.a:3 11 v2.b:1…
355 CREATE VIEW v2(x,y) AS SELECT a,b FROM t1 LIMIT 10;
357 execsql2 {SELECT * FROM v2 WHERE 1}
360 execsql2 {SELECT v2.x, [v2].[y] FROM v2 WHERE 1}
363 execsql2 {SELECT +x, +y FROM v2 WHERE 1}
H A Daltertab3.test495 CREATE VIEW v2(b) AS SELECT * FROM v2;
500 } {1 {error in view v2: view v2 is circularly defined}}
503 DROP VIEW v2;
504 CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) SELECT * FROM t3;
509 } {1 {error in view v2: view v2 is circularly defined}}
512 DROP VIEW v2;
513 CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) VALUES(1);
545 SELECT * FROM v2
553 } {1 {error in view v2: view v2 is circularly defined}}
576 DELETE FROM v2;
[all …]
H A Dlaststmtchanges.test107 create table t2 (k integer primary key, v1, v2);
111 update t2 set v2=changes();
128 select v2 from t2;
137 # 1 from "update t2 set v2=changes();"
154 update t2 set v2=changes();
171 select v2 from t2;
186 update t2 set v2=changes();
203 select v2 from t2;
220 create temp view v2 as select * from t2;
238 insert into v2 values (100+NEW.k);
[all …]
H A Djoin2.test118 CREATE TABLE t2(k2 INTEGER PRIMARY KEY, v2);
128 SELECT v2 FROM t1 LEFT JOIN t2 USING (k2) LEFT JOIN t3_1 USING (k3);
136 SELECT v2 FROM t1 LEFT JOIN t2 USING (k2) LEFT JOIN t3_2 USING (k3);
149 CREATE TABLE c2(k INTEGER PRIMARY KEY, v2);
161 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
176 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
196 CREATE TABLE c2(k UNIQUE, v2);
208 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
349 CREATE VIEW v2(ccc) AS SELECT bbb IS 1234 FROM t2;
350 SELECT ccc, ccc IS NULL AS ddd FROM t1 LEFT JOIN v2;
[all …]
H A Dwith2.test559 CREATE VIEW v2(c) AS
563 SELECT * FROM v2
571 SELECT * FROM v2;
574 DROP VIEW v2;
575 CREATE VIEW v2(c) AS
579 SELECT * FROM v2
582 SELECT * FROM v2;
585 DROP VIEW v2;
586 CREATE VIEW v2(c) AS
590 SELECT * FROM v2
[all …]
H A Dview.test139 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
142 SELECT * FROM v2;
147 INSERT INTO v2 VALUES(1,2,3,4);
149 } {1 {cannot modify v2 because it is a view}}
152 UPDATE v2 SET a=10 WHERE a=5;
154 } {1 {cannot modify v2 because it is a view}}
157 DELETE FROM v2;
159 } {1 {cannot modify v2 because it is a view}}
163 SELECT * FROM v2 ORDER BY x;
168 SELECT x FROM v2 WHERE a>10
[all …]
H A Dmalloc_common.tcl510 set v2 $msg
513 set v2 1
516 set v2 $msg
522 set v2 1
524 set v2 $msg
527 lappend isFail $v2
H A Dinsert5.test42 CREATE VIEW v2 AS SELECT * FROM MAIN;
90 uses_temp_table { INSERT INTO b SELECT * FROM v2 }
106 # WHERE id > 10 AND (SELECT count(*) FROM v2 GROUP BY main.id)
113 WHERE id > 10 AND (SELECT count(*) FROM v2 GROUP BY main.id)
H A DtriggerA.test58 CREATE VIEW v2 AS SELECT x, y FROM t1 WHERE y GLOB '*e*';
59 SELECT * FROM v2 ORDER BY 1;
112 CREATE TRIGGER r2d INSTEAD OF DELETE ON v2 BEGIN
115 DELETE FROM v2 WHERE x=5;
122 CREATE TRIGGER r2u INSTEAD OF UPDATE ON v2 BEGIN
125 UPDATE v2 SET y=y||'-extra' WHERE x BETWEEN 3 AND 5;
H A DwindowD.test77 CREATE VIEW v2 AS SELECT max(x) OVER () AS a, TRUE AS c FROM t1;
81 SELECT 500 IS c FROM v2;
85 SELECT * FROM v2 WHERE 500 IS c;
H A Dchanges2.test25 UPDATE some_table SET value='v2' WHERE id=1 RETURNING id
69 INSERT INTO t1 VALUES (1, 'v1'), (2, 'v2');
81 INSERT INTO t1 VALUES (3, 'v1'), (4, 'v2');
H A Dwith4.test35 CREATE VIEW v2 AS WITH v(m,n) AS (SELECT x,y FROM aux.t2) SELECT * FROM t1, v;
36 } {1 {view v2 cannot reference objects in database aux}}
38 CREATE VIEW v2 AS WITH v(m,n) AS (SELECT 5,?2) SELECT * FROM t1, v;
H A Dtabfunc01.test80 CREATE VIEW v2(x) AS SELECT value FROM generate_series(1,5);
81 SELECT * FROM v2;
84 SELECT * FROM v2(55);
85 } {1 {'v2' is not a function}}
87 SELECT * FROM v2();
88 } {1 {'v2' is not a function}}
H A Dview3.test32 CREATE VIEW v2 AS SELECT * FROM v1 UNION SELECT * FROM v1;
33 CREATE VIEW v4 AS SELECT * FROM v2 UNION SELECT * FROM v2;
H A Drowvalue.test25 foreach {tn v1 v2 eq ne is isnot} {
35 do_execsql_test 1.$tn.eq "SELECT ($v1) == ($v2)" [list $eq]
36 do_execsql_test 1.$tn.ne "SELECT ($v1) != ($v2)" [list $ne]
38 do_execsql_test 1.$tn.is "SELECT ($v1) IS ($v2)" [list $is]
39 do_execsql_test 1.$tn.isnot "SELECT ($v1) IS NOT ($v2)" [list $isnot]
41 do_execsql_test 1.$tn.2.eq "SELECT (SELECT $v1) == (SELECT $v2)" [list $eq]
45 foreach {tn v1 v2 lt gt le ge} {
55 2.$tn.lt "$v1 < $v2" $lt \
56 2.$tn.gt "$v1 > $v2" $gt \
57 2.$tn.le "$v1 <= $v2" $le \
[all …]
H A Dfts4noti.test114 set v2 "y $v"
118 INSERT INTO t2 VALUES(3, $v2);
119 INSERT INTO t2 VALUES(4, $v2);
120 INSERT INTO t2 VALUES(5, $v2);
121 INSERT INTO t2 VALUES(6, $v2);
H A Dschemafault.test21 CREATE VIEW v2(xxx , yyy) AS SELECT aaa, aaa+1 FROM t2;
26 execsql { SELECT * FROM v2 }
H A Dbind.test124 set v2 {$::two}
136 set v2 {:two}
148 } $v2
156 sqlite3_bind_parameter_index $VM $v2
491 set v2 {$ab}
503 set v2 {:xy}
512 sqlite3_bind_parameter_index $VM $v2
522 } $v2
H A Dwal_common.tcl30 foreach {v1 v2} $intlist {
32 set c2 [expr {($c2 + $v2 + $c1)&0xFFFFFFFF}]
H A Daffinity3.test38 CREATE VIEW v2 AS
65 SELECT id, (apr / 100), typeof(apr) apr_type FROM v2;
81 SELECT id, (apr / 100), typeof(apr) apr_type FROM v2;
/sqlite-3.40.0/ext/misc/
H A Dpercentile.c185 double v1, v2; in percentFinal() local
196 v2 = p->a[i2]; in percentFinal()
197 vx = v1 + (v2-v1)*(ix-i1); in percentFinal()

1234