Lines Matching refs:v1
579 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
583 } {v1 {} main {}}
595 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
599 } {v1 {} main {}}
612 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
616 } {v1 {} temp {}}
628 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
632 } {v1 {} temp {}}
644 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
656 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
669 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
681 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
772 CREATE TEMP VIEW v1 AS SELECT a+1,b+1 FROM t1;
773 DROP VIEW v1
778 } {t1 v1}
787 catchsql {DROP VIEW v1}
791 } {v1 {} temp {}}
794 } {t1 v1}
802 catchsql {DROP VIEW v1}
806 } {t1 v1}
815 catchsql {DROP VIEW v1}
819 } {v1 {} temp {}}
822 } {t1 v1}
831 catchsql {DROP VIEW v1}
835 } {v1 {} temp {}}
1847 CREATE VIEW v1 AS SELECT a+b AS x FROM t2;
1849 CREATE TRIGGER r2 INSTEAD OF UPDATE ON v1 BEGIN
1852 SELECT * FROM v1;
1858 UPDATE v1 SET x=1 WHERE x=117
1862 SQLITE_UPDATE v1 x main {} \
1863 SQLITE_READ v1 x main {} \
1864 SQLITE_SELECT {} {} {} v1 \
1865 SQLITE_READ t2 a main v1 \
1866 SQLITE_READ t2 b main v1 \
1868 SQLITE_READ v1 x main r2 \
1869 SQLITE_READ v1 x main r2]
1872 CREATE TRIGGER r3 INSTEAD OF DELETE ON v1 BEGIN
1875 SELECT * FROM v1;
1881 DELETE FROM v1 WHERE x=117
1885 SQLITE_DELETE v1 {} main {} \
1886 SQLITE_READ v1 x main {} \
1887 SQLITE_SELECT {} {} {} v1 \
1888 SQLITE_READ t2 a main v1 \
1889 SQLITE_READ t2 b main v1 \
1891 SQLITE_READ v1 x main r3]