Rules for Specifying constant Values - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

The following rules apply to a MVC specification that specifies a comma-separated list of constant values:

  • The maximum number of distinct constant values in the list is 255 plus NULL.
  • Values can appear in any order.
  • NULL can appear at any point in the multivalued constant list.
  • The multivalue list cannot contain duplicate values. Case variants are not considered duplicate values if UPPERCASE is not specified.
  • NULL cannot appear in the list if the column is declared NOT NULL.