HeatWave User Guide  /  ...  /  Data Type Limitations

11.2.1.1 Data Type Limitations

  • Review Column Limits for data types.

  • Spatial data types are unsupported. See Spatial Data Types.

  • The following string and text data types are unsupported:

  • Decimal values with a precision greater than 18 in expression operators are unsupported, with the exception of the following:

  • The following ENUM type columns are unsupported:

  • ENUM type support is limited to:

    • Comparison with string or numeric constants, and other numeric, non-temporal expressions (numeric columns, constants, and functions with a numeric result).

    • Comparison operators (<, <=, <=>, =, >=, >, and BETWEEN) with numeric arguments.

    • Comparison operators (=, <=>, and <>) with string constants.

    • enum_col IS [NOT] {NULL|TRUE|FALSE}

    • The IN() function in combination with numeric arguments (constants, functions, or columns) and string constants.

    • COUNT(), SUM(), and AVG() aggregation functions on ENUM columns. The functions operate on the numeric index value, not the associated string value.

    • CAST(enum_col AS {[N]CHAR [(X)]|SIGNED|UNSIGNED|FLOAT|DOUBLE|DECIMAL [(M,N)]}). The numeric index value is cast, not the associated string value.

    • CAST(enum_col) AS {[N]CHAR} is supported only in the SELECT list and when it is not nested in another expression.

  • Temporal types are supported only with strict SQL mode.