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.