Lines Matching refs:v1
581 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
585 } {v1 {} main {}}
597 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
601 } {v1 {} main {}}
614 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
618 } {v1 {} temp {}}
630 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
634 } {v1 {} temp {}}
646 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
658 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
671 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
683 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
774 CREATE TEMP VIEW v1 AS SELECT a+1,b+1 FROM t1;
775 DROP VIEW v1
780 } {t1 v1}
789 catchsql {DROP VIEW v1}
793 } {v1 {} temp {}}
796 } {t1 v1}
804 catchsql {DROP VIEW v1}
808 } {t1 v1}
817 catchsql {DROP VIEW v1}
821 } {v1 {} temp {}}
824 } {t1 v1}
833 catchsql {DROP VIEW v1}
837 } {v1 {} temp {}}
1849 CREATE VIEW v1 AS SELECT a+b AS x FROM t2;
1851 CREATE TRIGGER r2 INSTEAD OF UPDATE ON v1 BEGIN
1854 SELECT * FROM v1;
1860 UPDATE v1 SET x=1 WHERE x=117
1864 SQLITE_UPDATE v1 x main {} \
1865 SQLITE_READ v1 x main {} \
1866 SQLITE_SELECT {} {} {} v1 \
1867 SQLITE_READ t2 a main v1 \
1868 SQLITE_READ t2 b main v1 \
1870 SQLITE_READ v1 x main r2 \
1871 SQLITE_READ v1 x main r2]
1874 CREATE TRIGGER r3 INSTEAD OF DELETE ON v1 BEGIN
1877 SELECT * FROM v1;
1883 DELETE FROM v1 WHERE x=117
1887 SQLITE_DELETE v1 {} main {} \
1888 SQLITE_READ v1 x main {} \
1889 SQLITE_SELECT {} {} {} v1 \
1890 SQLITE_READ t2 a main v1 \
1891 SQLITE_READ t2 b main v1 \
1893 SQLITE_READ v1 x main r3]