Lines Matching refs:INSERT
19 # trigger2-1.3.*: INSERT trigger execution model.
23 # trigger program can correctly execute INSERT, UPDATE, DELETE * SELECT
45 # trigger2-6.1[a-f]: INSERT statements
77 INSERT INTO tbl VALUES(1, 2);
78 INSERT INTO tbl VALUES(3, 4);
85 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
93 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
102 INSERT INTO clog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM clog),
124 INSERT INTO tbl VALUES (100, 100);
125 INSERT INTO tbl VALUES (300, 200);
128 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
136 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
154 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
156 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
162 CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
164 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
174 INSERT INTO other_tbl VALUES(1, 2);
175 INSERT INTO other_tbl VALUES(3, 4);
176 -- INSERT INTO tbl SELECT * FROM other_tbl;
177 INSERT INTO tbl VALUES(5, 6);
202 {INSERT INTO log VALUES(new.c, 2, 3);}
204 {INSERT INTO tbl VALUES(500, new.b * 10, 700);
207 {INSERT INTO log select * from tbl;}
212 set prep {INSERT INTO tbl VALUES(1, 2, 3);}
222 set prep {INSERT INTO tbl VALUES(1, 2, 3);}
228 set statement {INSERT INTO tbl VALUES(1, 2, 3);}
255 if {$statement_type == "INSERT"} {
281 set prep "$prep; INSERT INTO log VALUES(1, 2, 3);\
282 INSERT INTO log VALUES(10, 20, 30);"
326 INSERT INTO log VALUES (0);
327 INSERT INTO tbl VALUES (0, 0, 0, 0);
328 INSERT INTO tbl VALUES (1, 0, 0, 0);
350 {t1 BEFORE INSERT ON tbl WHEN new.a > 20} \
351 {t2 BEFORE INSERT ON tbl WHEN (SELECT count(*) FROM tbl) = 0} ]
356 INSERT INTO log VALUES (0);
366 INSERT INTO tbl VALUES(0, 0, 0, 0); -- 1
370 INSERT INTO tbl VALUES(0, 0, 0, 0); -- 0
374 INSERT INTO tbl VALUES(200, 0, 0, 0); -- 1
395 CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
396 INSERT INTO tblB values(new.a, new.b);
399 CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
400 INSERT INTO tblC values(new.a, new.b);
405 INSERT INTO tblA values(1, 2);
420 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
422 INSERT INTO tbl VALUES (new.a, new.b, new.c);
427 INSERT INTO tbl VALUES (1, 2, 3);
438 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
440 INSERT INTO tbl VALUES (1, 2, 3);
441 INSERT INTO tbl VALUES (2, 2, 3);
449 INSERT INTO tbl VALUES(100, 200, 300);
457 # Handling of ON CONFLICT by INSERT statements inside triggers
460 CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
461 INSERT OR IGNORE INTO tbl values (new.a, 0, 0);
467 INSERT INTO tbl values (1, 2, 3);
473 INSERT OR ABORT INTO tbl values (2, 2, 3);
483 INSERT OR FAIL INTO tbl values (2, 2, 3);
493 INSERT OR REPLACE INTO tbl values (2, 2, 3);
499 INSERT OR ROLLBACK INTO tbl values (3, 2, 3);
512 INSERT INTO tbl values (4, 2, 3);
513 INSERT INTO tbl values (6, 3, 4);
553 INSERT INTO tbl VALUES (2, 3, 4);
576 INSERT INTO ab VALUES (1, 2);
577 INSERT INTO ab VALUES (0, 0);
578 INSERT INTO cd VALUES (3, 4);
586 INSERT INTO tlog VALUES(NULL,
590 INSERT INTO tlog VALUES(NULL,
595 INSERT INTO tlog VALUES(NULL,
599 INSERT INTO tlog VALUES(NULL,
603 CREATE TRIGGER before_insert INSTEAD OF INSERT ON abcd BEGIN
604 INSERT INTO tlog VALUES(NULL,
607 CREATE TRIGGER after_insert INSTEAD OF INSERT ON abcd BEGIN
608 INSERT INTO tlog VALUES(NULL,
618 INSERT INTO abcd VALUES(10, 20, 30, 40);
631 INSERT INTO abcd VALUES(10, 20, 30, 40);
648 INSERT INTO abcd VALUES(10, 20, 30, 40);
664 INSERT INTO t1 VALUES(1,2,3);
674 INSERT INTO v1log VALUES(OLD.x,NULL,OLD.y,NULL,OLD.z,NULL);
688 INSERT INTO t1 VALUES(4,5,6);
696 CREATE TRIGGER r2 INSTEAD OF INSERT ON v1 BEGIN
697 INSERT INTO v1log VALUES(NULL,NEW.x,NULL,NEW.y,NULL,NEW.z);
700 INSERT INTO v1 VALUES(1,2,3);
707 INSERT INTO v1log VALUES(OLD.x,NEW.x,OLD.y,NEW.y,OLD.z,NEW.z);