Lines Matching refs:trigger
17 # Note 2: changes() is changed within the context of a trigger much like
19 # the trigger exits.
21 # is done within instead of trigger context).
93 ifcapable {!trigger} {
100 # 2.x - tests with after insert trigger
102 # changes() changed properly after insert into table containing after trigger
108 create trigger r1 after insert on t1 for each row begin
118 # changes() unchanged upon entry into after insert trigger
125 # changes() changed properly by update within context of after insert trigger
132 # Total changes caused by firing the trigger above:
144 # 3.x - tests with after update trigger
146 # changes() changed properly after update into table containing after trigger
149 drop trigger r1;
151 create trigger r1 after update on t1 for each row begin
161 # changes() unchanged upon entry into after update trigger
168 # changes() changed properly by delete within context of after update trigger
176 # 4.x - tests with before delete trigger
178 # changes() changed properly on delete from table containing before trigger
181 drop trigger r1;
183 create trigger r1 before delete on t1 for each row begin
193 # changes() unchanged upon entry into before delete trigger
200 # changes() changed properly by insert within context of before delete trigger
231 create temp trigger r1 instead of insert on v1 for each row begin
241 create temp trigger r2 instead of insert on v2 for each row begin
