Lines Matching refs:v2
94 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
97 SELECT * FROM v2;
102 INSERT INTO v2 VALUES(1,2,3,4);
104 } {1 {cannot modify v2 because it is a view}}
107 UPDATE v2 SET a=10 WHERE a=5;
109 } {1 {cannot modify v2 because it is a view}}
112 DELETE FROM v2;
114 } {1 {cannot modify v2 because it is a view}}
118 SELECT * FROM v2 ORDER BY x;
123 SELECT x FROM v2 WHERE a>10
136 SELECT * FROM v2 LIMIT 1
248 SELECT min(x), min(a), min(b), min(c), min(a+b+c) FROM v2;
253 SELECT max(x), max(a), max(b), max(c), max(a+b+c) FROM v2;