Lines Matching refs:trigger

18 # Note 2: LSCC is changed within the context of a trigger
20 #           but is restored once the trigger exits
22 #           is done within instead of trigger context)
80 # 2.x - tests with after insert trigger
82 # LSCC changed properly after insert into table containing after trigger
87         create trigger r1 after insert on t1 for each row begin
97 # LSCC unchanged upon entry into after insert trigger
104 # LSCC changed properly by update within context of after insert trigger
112 # 3.x - tests with after update trigger
114 # LSCC changed properly after update into table containing after trigger
117         drop trigger r1;
119         create trigger r1 after update on t1 for each row begin
129 # LSCC unchanged upon entry into after update trigger
136 # LSCC changed properly by delete within context of after update trigger
144 # 4.x - tests with before delete trigger
146 # LSCC changed properly on delete from table containing before trigger
149         drop trigger r1;
151         create trigger r1 before delete on t1 for each row begin
161 # LSCC unchanged upon entry into before delete trigger
168 # LSCC changed properly by insert within context of before delete trigger
196         create temp trigger r1 instead of insert on v1 for each row begin
206         create temp trigger r2 instead of insert on v2 for each row begin