In this blog post, let’s learn about the error message “1132 An added column cannot have DEFAULT NULL and NOT NULL at the same time.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1132 An added column cannot have DEFAULT NULL and NOT NULL at the same time.
Reason for the Error
You attempted to add a column that is both DEFAULT NULL and NOT NULL.
Solution
Determine whether the column should be DEFAULT NULL or NOT NULL and resubmit
