17.05 - Use Consistent Predicate Domains - 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)

Specify consistent predicate domains in the WHERE clause search condition. For example, if min_level is defined as NUMERIC(5,2), then min_level values are compared with numeric values with greater precision in the WHERE condition, the result may not provide the accuracy you expect:

     WHERE min_level = 133.002