Lines Matching refs:ON
17 # trigger2-1.1.*: ON UPDATE trigger execution model.
44 # 6. ON CONFLICT clause handling
62 {CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
63 {CREATE TEMP TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
83 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
91 CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW
99 CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
126 CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
134 CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
154 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
162 CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
290 ON tbl BEGIN $tr_program_fixed END;"
302 ON tbl BEGIN $tr_program_fixed END;"
329 CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
350 {t1 BEFORE INSERT ON tbl WHEN new.a > 20} \
351 {t2 BEFORE INSERT ON tbl WHEN (SELECT count(*) FROM tbl) = 0} ]
395 CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
399 CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
420 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
438 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
457 # Handling of ON CONFLICT by INSERT statements inside triggers
460 CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
510 # Handling of ON CONFLICT by UPDATE statements inside triggers
514 CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
585 CREATE TRIGGER before_update INSTEAD OF UPDATE ON abcd BEGIN
589 CREATE TRIGGER after_update INSTEAD OF UPDATE ON abcd BEGIN
594 CREATE TRIGGER before_delete INSTEAD OF DELETE ON abcd BEGIN
598 CREATE TRIGGER after_delete INSTEAD OF DELETE ON abcd BEGIN
603 CREATE TRIGGER before_insert INSTEAD OF INSERT ON abcd BEGIN
607 CREATE TRIGGER after_insert INSTEAD OF INSERT ON abcd BEGIN
673 CREATE TRIGGER r1 INSTEAD OF DELETE ON v1 BEGIN
696 CREATE TRIGGER r2 INSTEAD OF INSERT ON v1 BEGIN
706 CREATE TRIGGER r3 INSTEAD OF UPDATE ON v1 BEGIN