Lines Matching refs:INSERT
21 # trigger2-1.3.*: INSERT trigger execution model.
25 # trigger program can correctly execute INSERT, UPDATE, DELETE * SELECT
47 # trigger2-6.1[a-f]: INSERT statements
79 INSERT INTO tbl VALUES(1, 2);
80 INSERT INTO tbl VALUES(3, 4);
87 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
95 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
104 INSERT INTO clog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM clog),
126 INSERT INTO tbl VALUES (100, 100);
127 INSERT INTO tbl VALUES (300, 200);
130 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
138 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
156 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
158 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
164 CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
166 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
176 INSERT INTO other_tbl VALUES(1, 2);
177 INSERT INTO other_tbl VALUES(3, 4);
178 -- INSERT INTO tbl SELECT * FROM other_tbl;
179 INSERT INTO tbl VALUES(5, 6);
204 {INSERT INTO log VALUES(new.c, 2, 3);}
206 {INSERT INTO tbl VALUES(500, new.b * 10, 700);
209 {INSERT INTO log select * from tbl;}
214 set prep {INSERT INTO tbl VALUES(1, 2, 3);}
224 set prep {INSERT INTO tbl VALUES(1, 2, 3);}
230 set statement {INSERT INTO tbl VALUES(1, 2, 3);}
257 if {$statement_type == "INSERT"} {
283 set prep "$prep; INSERT INTO log VALUES(1, 2, 3);\
284 INSERT INTO log VALUES(10, 20, 30);"
328 INSERT INTO log VALUES (0);
329 INSERT INTO tbl VALUES (0, 0, 0, 0);
330 INSERT INTO tbl VALUES (1, 0, 0, 0);
352 {t1 BEFORE INSERT ON tbl WHEN new.a > 20} \
353 {t2 BEFORE INSERT ON tbl WHEN (SELECT count(*) FROM tbl) = 0} ]
358 INSERT INTO log VALUES (0);
368 INSERT INTO tbl VALUES(0, 0, 0, 0); -- 1
372 INSERT INTO tbl VALUES(0, 0, 0, 0); -- 0
376 INSERT INTO tbl VALUES(200, 0, 0, 0); -- 1
397 CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
398 INSERT INTO tblB values(new.a, new.b);
401 CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
402 INSERT INTO tblC values(new.a, new.b);
407 INSERT INTO tblA values(1, 2);
422 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
424 INSERT INTO tbl VALUES (new.a, new.b, new.c);
429 INSERT INTO tbl VALUES (1, 2, 3);
440 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
442 INSERT INTO tbl VALUES (1, 2, 3);
443 INSERT INTO tbl VALUES (2, 2, 3);
451 INSERT INTO tbl VALUES(100, 200, 300);
459 # Handling of ON CONFLICT by INSERT statements inside triggers
462 CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
463 INSERT OR IGNORE INTO tbl values (new.a, 0, 0);
469 INSERT INTO tbl values (1, 2, 3);
475 INSERT OR ABORT INTO tbl values (2, 2, 3);
485 INSERT OR FAIL INTO tbl values (2, 2, 3);
495 INSERT OR REPLACE INTO tbl values (2, 2, 3);
501 INSERT OR ROLLBACK INTO tbl values (3, 2, 3);
514 INSERT INTO tbl values (4, 2, 3);
515 INSERT INTO tbl values (6, 3, 4);
555 INSERT INTO tbl VALUES (2, 3, 4);
578 INSERT INTO ab VALUES (1, 2);
579 INSERT INTO ab VALUES (0, 0);
580 INSERT INTO cd VALUES (3, 4);
588 INSERT INTO tlog VALUES(NULL,
592 INSERT INTO tlog VALUES(NULL,
597 INSERT INTO tlog VALUES(NULL,
601 INSERT INTO tlog VALUES(NULL,
605 CREATE TRIGGER before_insert INSTEAD OF INSERT ON abcd BEGIN
606 INSERT INTO tlog VALUES(NULL,
609 CREATE TRIGGER after_insert INSTEAD OF INSERT ON abcd BEGIN
610 INSERT INTO tlog VALUES(NULL,
620 INSERT INTO abcd VALUES(10, 20, 30, 40);
633 INSERT INTO abcd VALUES(10, 20, 30, 40);
650 INSERT INTO abcd VALUES(10, 20, 30, 40);
666 INSERT INTO t1 VALUES(1,2,3);
676 INSERT INTO v1log VALUES(OLD.x,NULL,OLD.y,NULL,OLD.z,NULL);
690 INSERT INTO t1 VALUES(4,5,6);
698 CREATE TRIGGER r2 INSTEAD OF INSERT ON v1 BEGIN
699 INSERT INTO v1log VALUES(NULL,NEW.x,NULL,NEW.y,NULL,NEW.z);
702 INSERT INTO v1 VALUES(1,2,3);
709 INSERT INTO v1log VALUES(OLD.x,NEW.x,OLD.y,NEW.y,OLD.z,NEW.z);