Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb


HeatWave User Guide  /  ...  /  VARLEN Supported Expressions, Filters, Functions, and Operators

11.4.1.1 VARLEN Supported Expressions, Filters, Functions, and Operators

For supported functions and operators, refer to Section 11.2, “Supported Functions and Operators”.

VARLEN Supported Filters
  • Column-to-column filters, excluding the <=> filter. Both columns must be VARLEN-encoded.

    Column-to-column filters must use columns that are encoded with the same character set and collation.

  • Column-to-constant filters, excluding the <=> filter.

    The character set and collation of the constant variable must match the character set and collation of the constant.

VARLEN Supported Relational Operators
  • GROUP BY

  • JOIN

  • LIMIT

  • ORDER BY