HPE NonStop SQL/MX Error – 1295 Target column ColumnName has mismatching default type.

In this blog post, let’s learn about the error message “1295 Target column ColumnName has mismatching default type.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1295 Target column ColumnName has mismatching default type.

Reason for the Error

The data type of the specified default value for the column does not match the column data type.

Solution

Specify a default value of a matching data type for the column