Lines Matching refs:v1
34 CREATE VIEW v1 AS SELECT a,b FROM t1;
35 SELECT * FROM v1 ORDER BY a;
41 SELECT * FROM v1 ORDER BY a;
43 } {1 {no such table: v1}}
46 CREATE VIEW v1 AS SELECT a,b FROM t1;
47 SELECT * FROM v1 ORDER BY a;
54 SELECT * FROM v1 ORDER BY a;
59 DROP VIEW v1;
60 SELECT * FROM v1 ORDER BY a;
62 } {1 {no such table: v1}}
65 CREATE VIEW v1 AS SELECT a,b FROM t1;
66 SELECT * FROM v1 ORDER BY a;
72 SELECT * FROM v1 ORDER BY a;
81 SELECT * FROM v1 ORDER BY a;
88 SELECT * FROM v1 ORDER BY a;
131 SELECT * FROM v1 LIMIT 1
141 DROP VIEW v1;
142 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
143 SELECT * FROM v1 LIMIT 1
176 DROP TABLE v1;
178 } {1 {use DROP VIEW to delete view v1}}
181 SELECT 1 FROM v1 LIMIT 1;
186 CREATE INDEX i1v1 ON v1(xyz);
311 CREATE VIEW v6 AS SELECT pqr, xyz FROM v1;