XA END is treated as the transaction commit instead of XA PREPARE

The XA END only moves the transaction from the ACTIVE state to the IDLE state. The XA PREPARE is the actual command that marks the transaction as PREPARED which is the first commit step. The XA COMMIT xid ONE PHASE also needs to be treated as the transaction commit as it does both commits at the same time.

The effect of this is that with transaction replay, a failure during XA END, which should not prevent a retry, prevents a retry as it's treated as a commit.