In this blog post, let’s learn about the error message “1254 Duplicate unique constraints are not allowed with same set of columns.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1254 Duplicate unique constraints are not allowed with same set of columns.
Reason for the Error
You attempted to specify both the unique and primary key constraints or multiple unique constraints on the same set of columns, which is not allowed.
Solution
Change your query so that both unique and primary constraints or multiple unique constraints are not specified on the same set of columns