Use Consistent Predicate Domains - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

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
     …