当在触发器的处理过程中抛出异常时，触发器终止，导致触发器触发的整个语句回退。

When an exception is thrown during processing of a trigger, the trigger aborts, and the entire statement that caused the trigger to fire is rolled back.

youdao

没有事务名称或保存点名称的ROLLBACK语句总是将语句回退到最外层的BEGIN TRANSACTION(显式或隐式)语句，并且取消整个事务。

ROLLBACK statement without a transaction or savepoint name always rolls back statements to the outermost BEGIN transaction (explicit or implicit) statement, and cancels the entire transaction.

youdao