Lines Matching refs:v2

42   CREATE VIEW v2 AS SELECT 15,22;
45 } {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 |}
92     SELECT * FROM t1, v2;
99 } {view t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
103     SELECT * FROM t1, v2;
111 } {table t1 t1 | index i1 tx | view v2 v2 | trigger r1 t1 |}
115     SELECT * FROM t1, v2;
122 } {table t1 t1 | table i1 t1 | view v2 v2 | trigger r1 t1 |}
126     SELECT * FROM t1, v2;
133 } {table t1 t1 | view i1 t1 | view v2 v2 | trigger r1 t1 |}
137     SELECT * FROM t1, v2;
143   UPDATE sqlite_master SET type='table', tbl_name='v2' WHERE name='v2';
145 } {table t1 t1 | index i1 t1 | table v2 v2 | trigger r1 t1 |}
149     SELECT * FROM t1, v2;
151 } {1 {malformed database schema (v2)}}
154   UPDATE sqlite_master SET type='view',name='v3',tbl_name='v3' WHERE name='v2';
160     SELECT * FROM t1, v2;
165   UPDATE sqlite_master SET type='view',name='v2',tbl_name='v2' WHERE name='v3';
168 } {table t1 t1 | index i1 t1 | view v2 v2 | view r1 t1 |}
172     SELECT * FROM t1, v2;
176   UPDATE sqlite_master SET type='trigger',tbl_name='v2' WHERE name='r1';
178 } {table t1 t1 | index i1 t1 | view v2 v2 | trigger r1 v2 |}
182     SELECT * FROM t1, v2;