Lines Matching refs:v1

37     CREATE VIEW IF NOT EXISTS v1 AS SELECT a,b FROM t1;
38     SELECT * FROM v1 ORDER BY a;
44     SELECT * FROM v1 ORDER BY a;
46 } {1 {access to view "v1" prohibited}}
54     SELECT * FROM v1 ORDER BY a;
60     SELECT name, type FROM pragma_table_list('v1');
61   } {v1 view}
66     SELECT * FROM v1 ORDER BY a;
68 } {1 {no such table: v1}}
71     CREATE VIEW v1 AS SELECT a,b FROM t1;
72     SELECT * FROM v1 ORDER BY a;
79     SELECT * FROM v1 ORDER BY a;
84     DROP VIEW IF EXISTS v1;
85     SELECT * FROM v1 ORDER BY a;
87 } {1 {no such table: v1}}
90     CREATE VIEW v1 AS SELECT a,b FROM t1;
91     SELECT * FROM v1 ORDER BY a;
97     SELECT * FROM v1 ORDER BY a;
106     SELECT * FROM v1 ORDER BY a;
113     SELECT * FROM v1 ORDER BY a;
176     SELECT * FROM v1 LIMIT 1
186     DROP VIEW v1;
187     CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
188     SELECT * FROM v1 LIMIT 1
249     DROP TABLE v1;
251 } {1 {use DROP VIEW to delete view v1}}
254      SELECT 1 FROM v1 LIMIT 1;
259     CREATE INDEX i1v1 ON v1(xyz);
388     CREATE VIEW v6 AS SELECT pqr, xyz FROM v1;
568     CREATE VIEW IF NOT EXISTS v1 AS SELECT * FROM t1;
573     SELECT sql FROM sqlite_master WHERE name='v1'
575 } {{CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1}}
646     DROP VIEW IF EXISTS v1;
648     CREATE VIEW v1 AS SELECT c1 FROM (SELECT t1.c1 FROM t1);