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
