Test cases for violating a constraint in the same transaction that creates it.
Make constraint indexes online once they have completed scan - allows checking the constraint in the same transaction.
Verify properterties added in the same transaction as a constraint is created.