In this blog post, let’s learn about the error message “1053 Unique index index-name could not be created because the specified column(s) contain duplicate data.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1053 Unique index index-name could not be created because the specified column(s) contain duplicate data.
Reason for the Error
The rows existing in the table violate the uniqueness constraint specified in the CREATE INDEX statement.
Solution
Either change the list of columns for the unique index, or change the rows in the table to remove duplicates. Then reissue the statement
