Ask some questions about transaction.

[perfy576]

I understand that surrealdb cannot be like mysql, the expression of a transaction is submitted multiple times. The transaction of surrealdb can only put all requests on the same request total submission.
And I found out that CANCEL TRANSACTION cannot be used in else statement.

Based on this, what is the meaning of CANCEL TRANSACTION, if there is CANCEL TRANSACTION in the statement, then all expressions will not be executed. That being the case, I don't need to send any more requests with CANCEL TRANSACTION .

Please tell me, in what scenario should I use CANCEL TRANSACTION or how can I execute CANCEL TRANSACTION based on some condition judgment