Lines Matching refs:v1
594 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
598 } {v1 {} main {}}
610 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
614 } {v1 {} main {}}
628 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
632 } {v1 {} temp {}}
644 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
648 } {v1 {} temp {}}
661 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
673 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
687 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
699 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
792 CREATE TEMP VIEW v1 AS SELECT a+1,b+1 FROM t1;
793 DROP VIEW v1
798 } {t1 v1}
807 catchsql {DROP VIEW v1}
811 } {v1 {} temp {}}
814 } {t1 v1}
822 catchsql {DROP VIEW v1}
826 } {t1 v1}
835 catchsql {DROP VIEW v1}
839 } {v1 {} temp {}}
842 } {t1 v1}
851 catchsql {DROP VIEW v1}
855 } {v1 {} temp {}}
2413 CREATE VIEW v1 AS SELECT a+b AS x FROM t2;
2415 CREATE TRIGGER r2 INSTEAD OF UPDATE ON v1 BEGIN
2418 SELECT * FROM v1;
2424 UPDATE v1 SET x=1 WHERE x=117
2428 SQLITE_UPDATE v1 x main {} \
2429 SQLITE_SELECT {} {} {} v1 \
2430 SQLITE_READ t2 a main v1 \
2431 SQLITE_READ t2 b main v1 \
2432 SQLITE_READ v1 x main v1 \
2433 SQLITE_READ v1 x main v1 \
2434 SQLITE_SELECT {} {} {} v1 \
2435 SQLITE_READ v1 x main v1 \
2437 SQLITE_READ v1 x main r2 \
2438 SQLITE_READ v1 x main r2 \
2443 CREATE TRIGGER r3 INSTEAD OF DELETE ON v1 BEGIN
2446 SELECT * FROM v1;
2452 DELETE FROM v1 WHERE x=117
2456 SQLITE_DELETE v1 {} main {} \
2457 SQLITE_SELECT {} {} {} v1 \
2458 SQLITE_READ t2 a main v1 \
2459 SQLITE_READ t2 b main v1 \
2460 SQLITE_READ v1 x main v1 \
2461 SQLITE_READ v1 x main v1 \
2462 SQLITE_SELECT {} {} {} v1 \
2463 SQLITE_READ v1 x main v1 \
2465 SQLITE_READ v1 x main r3 \