The ROLLBACK statement would fail with the error: Rollback to savepoint disallowed on updating an old server in same transaction.
ROLLBACK 语句将失败并收到一个错误:保存点回滚不允许在同一事务中更新较旧的服务器。
When you rollback to a savepoint set earlier in a transaction, IDS just rolls back all the operations logged by the transaction after the savepoint was set.
当回滚到事务中早先设置的保存点时,IDS将只回滚在设置保存点后由事务记录的所有操作。
Although the new order cannot be entered, the new customer addition still passes with the procedure execution, and is rolled back with the final rollback to savepoint in the main transaction.
尽管不能输入新的订单,但是添加新客户的操作仍然通过了过程执行,并且通过在主事务中最后的保存点回滚完成了回滚。
应用推荐