In this blog post, let’s learn about the error message “1251 The extra insignificant digits of default value value are truncated to match the scale of the data type of column column-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1251 The extra insignificant digits of default value value are truncated to match the scale of the data type of column column-name.
Reason for the Error
A CREATE TABLE or ALTER TABLE…ADD COLUMN specified a default value with a scale greater than the scale of the column.
Solution
None. This is a warning message only