Lines Matching refs:v2
92 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
95 SELECT * FROM v2;
100 INSERT INTO v2 VALUES(1,2,3,4);
102 } {1 {cannot modify v2 because it is a view}}
105 UPDATE v2 SET a=10 WHERE a=5;
107 } {1 {cannot modify v2 because it is a view}}
110 DELETE FROM v2;
112 } {1 {cannot modify v2 because it is a view}}
116 SELECT * FROM v2 ORDER BY x;
121 SELECT x FROM v2 WHERE a>10
134 SELECT * FROM v2 LIMIT 1
246 SELECT min(x), min(a), min(b), min(c), min(a+b+c) FROM v2;
251 SELECT max(x), max(a), max(b), max(c), max(a+b+c) FROM v2;