BUG#24454378: Fix such that only unique indexes fires for deferred constraints, BUG#23539733: Added test cases also for BUG#24453949, BUG24454093 and BUG24454378