I recreated your example and I got the same results, but I found an interesting difference when the failure is a result of a Not NULL constraint.

Alter table...