Lines Matching refs:v1

153       CREATE VIEW v1 AS SELECT * FROM t3;
154       CREATE TRIGGER trig1 INSTEAD OF UPDATE ON v1 BEGIN
157       UPDATE v1 SET b = 'hello';
170       CREATE VIEW v1 AS SELECT a, b AS c FROM t3 WHERE c > 'one';
171       CREATE TRIGGER trig1 INSTEAD OF UPDATE ON v1 BEGIN
174       UPDATE v1 SET c = 'hello';
184       CREATE VIEW v1 AS SELECT DISTINCT a, b FROM t3;
185       CREATE TRIGGER trig1 INSTEAD OF UPDATE ON v1 BEGIN
188       UPDATE v1 SET b = 'hello';
199         CREATE VIEW v1 AS SELECT a, b FROM t3 EXCEPT SELECT 1, 'one';
200         CREATE TRIGGER trig1 INSTEAD OF UPDATE ON v1 BEGIN
203         UPDATE v1 SET b = 'hello';
212         CREATE VIEW v1 AS 
214         CREATE TRIGGER trig1 INSTEAD OF UPDATE ON v1 BEGIN
217         UPDATE v1 SET b = 'hello';
230   CREATE VIEW v1 AS SELECT a, b FROM t1;
232   CREATE TRIGGER tr1 INSTEAD OF DELETE ON v1 BEGIN
236   CREATE TRIGGER tr2 INSTEAD OF UPDATE ON v1 BEGIN
240   CREATE TRIGGER tr3 INSTEAD OF INSERT ON v1 BEGIN
246   DELETE FROM v1 WHERE rowid=1;
250   UPDATE v1 SET a=b WHERE rowid=2;