Lines Matching refs:trigger

19 # Note 3: LIRID is changed within the context of a trigger,
20 #           but is restored once the trigger exits
22 #           is done within instead of trigger context)
68 # 2.x - tests with after insert trigger
70 # LIRID changed properly after an insert into table containing an after trigger
74         create trigger r1 after insert on t1 for each row begin
84 # LIRID equals NEW.k upon entry into after insert trigger
91 # LIRID changed properly by insert within context of after insert trigger
98 # LIRID unchanged by update within context of after insert trigger
106 # 3.x - tests with after update trigger
108 # LIRID not changed after an update onto a table containing an after trigger
112         drop trigger r1;
113         create trigger r1 after update on t1 for each row begin
123 # LIRID unchanged upon entry into after update trigger
130 # LIRID changed properly by insert within context of after update trigger
137 # LIRID unchanged by update within context of after update trigger
145 # 4.x - tests with instead of insert trigger
147 # LIRID not changed after an insert into view containing an instead of trigger
151         drop trigger r1;
152         create trigger r1 instead of insert on v for each row begin
162 # LIRID unchanged upon entry into instead of trigger
169 # LIRID changed properly by insert within context of instead of trigger
176 # LIRID unchanged by update within context of instead of trigger
184 # 5.x - tests with before delete trigger
186 # LIRID not changed after a delete on a table containing a before trigger
190         drop trigger r1;
191         create trigger r1 before delete on t1 for each row begin
201 # LIRID unchanged upon entry into delete trigger
208 # LIRID changed properly by insert within context of delete trigger
215 # LIRID unchanged by update within context of delete trigger
223 # 6.x - tests with instead of update trigger
225 # LIRID not changed after an update on a view containing an instead of trigger
229         drop trigger r1;
230         create trigger r1 instead of update on v for each row begin
240 # LIRID unchanged upon entry into instead of trigger
247 # LIRID changed properly by insert within context of instead of trigger
254 # LIRID unchanged by update within context of instead of trigger
266         drop table t1; drop table t2; drop trigger r1;
274         create temp trigger r1 instead of insert on v1 for each row begin
280         create temp trigger r2 instead of insert on v2 for each row begin