16.20 - Restrictions on the Data Types in a COALESCE Expression - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

The following restrictions apply to CLOB, BLOB, and UDT types in a COALESCE expression.

Data Type Restrictions
BLOB A BLOB can only appear in the argument list when it is cast to BYTE or VARBYTE.
CLOB A CLOB can only appear in the argument list when it is cast to CHAR or VARCHAR.
UDT Multiple UDTs can appear in the argument list only when they are identical types because Teradata Database does not perform implicit type conversion on UDTs in a COALESCE expression.