Triggers invoke the following behavior when fired as the result of an UPDATE (Upsert Form) request:
|Trigger Defined on this Action||Description|
|UPDATE||Fired in all cases for qualified rows.
No insert triggers are performed.
|INSERT||Fired only if no row is updated and the INSERT is performed.|
If no rows qualify, then no triggers are fired.
Triggers are fired as if the UPDATE and INSERT components in the atomic upsert request are performed as separate statements: unconditionally for UPDATE and conditionally for INSERT. The INSERT is performed only when no rows qualify for the UPDATE.