Lines Matching refs:y1
263 CREATE TABLE y1(a);
266 CREATE TRIGGER r1 AFTER DELETE ON y1 FOR EACH ROW BEGIN
269 INSERT INTO y1 VALUES(1);
270 INSERT INTO y1 VALUES(2);
271 INSERT INTO y1 SELECT a+2 FROM y1;
272 INSERT INTO y1 SELECT a+4 FROM y1;
273 INSERT INTO y1 SELECT a+8 FROM y1;
274 INSERT INTO y1 SELECT a+16 FROM y1;
275 INSERT INTO y2 SELECT a FROM y1;
277 SELECT count(*) FROM y1;
282 DELETE FROM y1;
283 SELECT count(*) FROM y1;