Lines Matching refs:y1
308 CREATE TABLE y1(a);
311 CREATE TRIGGER r1 AFTER DELETE ON y1 FOR EACH ROW BEGIN
314 INSERT INTO y1 VALUES(1);
315 INSERT INTO y1 VALUES(2);
316 INSERT INTO y1 SELECT a+2 FROM y1;
317 INSERT INTO y1 SELECT a+4 FROM y1;
318 INSERT INTO y1 SELECT a+8 FROM y1;
319 INSERT INTO y1 SELECT a+16 FROM y1;
320 INSERT INTO y2 SELECT a FROM y1;
322 SELECT count(*) FROM y1;
327 DELETE FROM y1;
328 SELECT count(*) FROM y1;