Lines Matching refs:v2

139     CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
142     SELECT * FROM v2;
147     INSERT INTO v2 VALUES(1,2,3,4);
149 } {1 {cannot modify v2 because it is a view}}
152     UPDATE v2 SET a=10 WHERE a=5;
154 } {1 {cannot modify v2 because it is a view}}
157     DELETE FROM v2;
159 } {1 {cannot modify v2 because it is a view}}
163     SELECT * FROM v2 ORDER BY x;
168     SELECT x FROM v2 WHERE a>10
181     SELECT * FROM v2 LIMIT 1
325     SELECT min(x), min(a), min(b), min(c), min(a+b+c) FROM v2;
330     SELECT max(x), max(a), max(b), max(c), max(a+b+c) FROM v2;