HPE NonStop SQL/MX Error – 4055 The select lists or tuples must have comparable data types. type1 and type2 are not comparable.

In this blog post, let’s learn about the error message “4055 The select lists or tuples must have comparable data types. type1 and type2 are not comparable.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4055 The select lists or tuples must have comparable data types. type1 and type2 are not comparable.

Reason for the Error

You specified select lists or tuples with incompatible datatypes.

Solution

Correct the syntax and resubmit