I think the issue you are missing is that the statement is executed as part of a session (implied if you don't create one), and a result of the error is to roll back the session so it is as if it never happened.
I think the issue you are missing is that the statement is executed as part of a session (implied if you don't create one), and a result of the error is to roll back the session so it is as if it never happened.