Lines Matching refs:y1
261 CREATE TABLE y1(a);
264 CREATE TRIGGER r1 AFTER DELETE ON y1 FOR EACH ROW BEGIN
267 INSERT INTO y1 VALUES(1);
268 INSERT INTO y1 VALUES(2);
269 INSERT INTO y1 SELECT a+2 FROM y1;
270 INSERT INTO y1 SELECT a+4 FROM y1;
271 INSERT INTO y1 SELECT a+8 FROM y1;
272 INSERT INTO y1 SELECT a+16 FROM y1;
273 INSERT INTO y2 SELECT a FROM y1;
275 SELECT count(*) FROM y1;
280 DELETE FROM y1;
281 SELECT count(*) FROM y1;