Lines Matching refs:t1

39   CREATE TABLE t1(a,b,c);
40   INSERT INTO t1 VALUES(111,222,333);
41   CREATE INDEX i1 ON t1(b);
43   CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN SELECT 5; END;
45 } {table t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
48   UPDATE sqlite_master SET tbl_name=NULL WHERE name='t1';
50 } {table t1 {} | index i1 t1 | view v2 v2 | trigger r1 t1 |}
55 } {1 {malformed database schema (t1)}}
58   UPDATE sqlite_master SET tbl_name='tx' WHERE name='t1';
60 } {table t1 tx | index i1 t1 | view v2 v2 | trigger r1 t1 |}
65 } {1 {malformed database schema (t1)}}
67   UPDATE sqlite_master SET tbl_name='t1', type='tabl' WHERE name='t1';
69 } {tabl t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
74 } {1 {malformed database schema (t1)}}
76   UPDATE sqlite_master SET tbl_name='t9',type='table',name='t9'WHERE name='t1';
78 } {table t9 t9 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
86   UPDATE sqlite_master SET name='t1',tbl_name='T1' WHERE name='t9';
88 } {table t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
92     SELECT * FROM t1, v2;
97   UPDATE sqlite_master SET type='view' WHERE name='t1';
99 } {view t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
103     SELECT * FROM t1, v2;
105 } {1 {malformed database schema (t1)}}
108   UPDATE sqlite_master SET type='table', tbl_name='t1' WHERE name='t1';
111 } {table t1 t1 | index i1 tx | view v2 v2 | trigger r1 t1 |}
115     SELECT * FROM t1, v2;
120   UPDATE sqlite_master SET type='table', tbl_name='t1' WHERE name='i1';
122 } {table t1 t1 | table i1 t1 | view v2 v2 | trigger r1 t1 |}
126     SELECT * FROM t1, v2;
131   UPDATE sqlite_master SET type='view', tbl_name='t1' WHERE name='i1';
133 } {table t1 t1 | view i1 t1 | view v2 v2 | trigger r1 t1 |}
137     SELECT * FROM t1, v2;
142   UPDATE sqlite_master SET type='index', tbl_name='t1' WHERE name='i1';
145 } {table t1 t1 | index i1 t1 | table v2 v2 | trigger r1 t1 |}
149     SELECT * FROM t1, v2;
156 } {table t1 t1 | index i1 t1 | view v3 v3 | trigger r1 t1 |}
160     SELECT * FROM t1, v2;
168 } {table t1 t1 | index i1 t1 | view v2 v2 | view r1 t1 |}
172     SELECT * FROM t1, v2;
178 } {table t1 t1 | index i1 t1 | view v2 v2 | trigger r1 v2 |}
182     SELECT * FROM t1, v2;