17.10 - Example: Using an IN List that Contains Multiple Columns with an Incompatible Data Type - Advanced SQL Engine - Teradata Database

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

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.

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.