Lines Matching refs:v2

495   CREATE VIEW v2(b) AS SELECT * FROM v2;
500 } {1 {error in view v2: view v2 is circularly defined}}
503   DROP VIEW v2;
504   CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) SELECT * FROM t3;
509 } {1 {error in view v2: view v2 is circularly defined}}
512   DROP VIEW v2;
513   CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) VALUES(1);
539   CREATE VIEW v2 (v3) AS 
540     WITH x1 AS (SELECT * FROM v2) 
541     SELECT v3 AS x, v3 AS y FROM v2; 
545   SELECT * FROM v2
546 } {1 {view v2 is circularly defined}}
553 } {1 {error in view v2: view v2 is circularly defined}}
560   CREATE TABLE v2 (v3 INTEGER UNIQUE ON CONFLICT ABORT); 
561   CREATE TRIGGER x AFTER INSERT ON v2 WHEN ( 
562       ( SELECT v1 AS PROMO_REVENUE FROM v2 JOIN v0 USING ( VALUE ) ) AND 0 ) 
564     DELETE FROM v2; 
573   CREATE TRIGGER x AFTER INSERT ON v2 WHEN (
576     DELETE FROM v2;
583 } {{CREATE TRIGGER x AFTER INSERT ON v2 WHEN (
586     DELETE FROM v2;