17.05 - Data Type of Nulls - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

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

When you specify an explicit NULL for any intersection operation, its data type is INTEGER. For an example of this principle using the UNION operator, see Example: Effect of Explicit NULLs on Data Type of a UNION.

On the other hand, column data defined as NULL has neither value nor data type and evaluates like any other null in a scalar expression.