16.20 - Example: Using an IN List that Contains Multiple Columns with an Incompatible Data Type - 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

In this example, the star1p table is altered to contain a new column Q401Sales with a VARCHAR(20) data type. The Q101Sales column is an INTEGER data type, and the Q401Sales is VARCHAR.

The INTEGER and VARCHAR data types are not compatible.

SELECT *
FROM star1p UNPIVOT (measure_value  FOR  yr_qtr_measure IN
(Q101Sales, Q401Sales)) Tmp;

Error 9134 Failure in TD_Unpivot contract function. Error determining column type of value columns.