Lines Matching refs:t2
215 CREATE TEMP TABLE t2(x,y);
219 INSERT INTO t2 VALUES(NEW.a,NEW.b);
226 SELECT * FROM t2;
228 } {1 {no such table: main.t2}}
238 SELECT * FROM t2;
240 } {1 {no such table: main.t2}}
243 CREATE TEMP TABLE t2(x,y);
245 SELECT * FROM t2;
247 } {1 {no such table: main.t2}}
252 INSERT INTO t2 VALUES(NEW.a,NEW.b);
255 SELECT * FROM t2;
260 DROP TABLE t2;
261 CREATE TABLE t2(x,y);
262 SELECT * FROM t2;
268 SELECT * FROM t1 UNION ALL SELECT * FROM t2;
276 SELECT * FROM t1 UNION ALL SELECT * FROM t2;
283 INSERT INTO t2 VALUES(NEW.a,NEW.b);
286 SELECT * FROM t2;
296 SELECT * FROM t2;
302 SELECT * FROM t2;
309 SELECT * FROM t2;
321 } {view v1 table t2}
324 CREATE TRIGGER t2 BEFORE DELETE ON t2 BEGIN
329 } {view v1 table t2 trigger t2}
331 catchsql {DELETE FROM t2}
334 execsql {SELECT * FROM t2}
340 } {view v1 table t2 trigger t2}
343 DROP TRIGGER t2;
346 } {view v1 table t2}
348 execsql {SELECT * FROM t2}
353 execsql {SELECT * FROM t2}
363 CREATE TRIGGER 'trigger' AFTER INSERT ON t2 BEGIN SELECT 1; END;
375 CREATE TRIGGER "trigger" AFTER INSERT ON t2 BEGIN SELECT 1; END;
387 CREATE TRIGGER [trigger] AFTER INSERT ON t2 BEGIN SELECT 1; END;
419 DROP TABLE t2;
444 CREATE temp TABLE t2(a, b, c);
453 CREATE TEMP TRIGGER trig2 AFTER INSERT ON t2 BEGIN
464 INSERT INTO t2 VALUES(4, 5, 6);
477 INSERT INTO t2 VALUES(4, 5, 6);
491 INSERT INTO t2 VALUES(14, 15, 16);
512 INSERT INTO t2 VALUES(24, 25, 26);