Lines Matching full:t2
213 CREATE TEMP TABLE t2(x,y);
217 INSERT INTO t2 VALUES(NEW.a,NEW.b);
224 SELECT * FROM t2;
226 } {1 {no such table: main.t2}}
236 SELECT * FROM t2;
238 } {1 {no such table: main.t2}}
241 CREATE TEMP TABLE t2(x,y);
243 SELECT * FROM t2;
245 } {1 {no such table: main.t2}}
250 INSERT INTO t2 VALUES(NEW.a,NEW.b);
253 SELECT * FROM t2;
258 DROP TABLE t2;
259 CREATE TABLE t2(x,y);
260 SELECT * FROM t2;
266 SELECT * FROM t1 UNION ALL SELECT * FROM t2;
274 SELECT * FROM t1 UNION ALL SELECT * FROM t2;
281 INSERT INTO t2 VALUES(NEW.a,NEW.b);
284 SELECT * FROM t2;
294 SELECT * FROM t2;
300 SELECT * FROM t2;
307 SELECT * FROM t2;
319 } {view v1 table t2}
322 CREATE TRIGGER t2 BEFORE DELETE ON t2 BEGIN
327 } {view v1 table t2 trigger t2}
329 catchsql {DELETE FROM t2}
332 execsql {SELECT * FROM t2}
338 } {view v1 table t2 trigger t2}
341 DROP TRIGGER t2;
344 } {view v1 table t2}
346 execsql {SELECT * FROM t2}
351 execsql {SELECT * FROM t2}
361 CREATE TRIGGER 'trigger' AFTER INSERT ON t2 BEGIN SELECT 1; END;
373 CREATE TRIGGER "trigger" AFTER INSERT ON t2 BEGIN SELECT 1; END;
385 CREATE TRIGGER [trigger] AFTER INSERT ON t2 BEGIN SELECT 1; END;
417 DROP TABLE t2;
442 CREATE temp TABLE t2(a, b, c);
451 CREATE TEMP TRIGGER trig2 AFTER INSERT ON t2 BEGIN
462 INSERT INTO t2 VALUES(4, 5, 6);
475 INSERT INTO t2 VALUES(4, 5, 6);
489 INSERT INTO t2 VALUES(14, 15, 16);
510 INSERT INTO t2 VALUES(24, 25, 26);