Lines Matching refs:VIEW

73   CREATE VIEW v1 AS SELECT * FROM t1 WHERE a=1 OR (b IN ());
82 } {{CREATE VIEW v1 AS SELECT * FROM t1 WHERE a=1 OR (b IN ())}}
226   CREATE VIEW v1 AS SELECT * FROM t1 WHERE (
235   {CREATE VIEW v1 AS SELECT * FROM t1 WHERE (
422     CREATE VIEW q AS SELECT 123
433     CREATE VIEW q AS SELECT
453     CREATE VIEW q AS SELECT 99 WINDOW x AS (RANGE BETWEEN UNBOUNDED PRECEDING
459     DROP VIEW IF EXISTS q;
483   CREATE VIEW v AS SELECT ( 
495   CREATE VIEW v2(b) AS SELECT * FROM v2;
503   DROP VIEW v2;
504   CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) SELECT * FROM t3;
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