5.3.3 Cast Functions and Operators

The following operations are supported with the CAST() function.

• CAST() from and to all the MySQL HeatWave supported numeric, temporal, string and text data types. See Section 4.2.1, “Supported Data Types for MySQL HeatWave”.

• CAST() of ENUM columns to CHAR, DECIMAL, FLOAT, and to SIGNED and UNSIGNED numeric values. CAST() operates on the ENUM index rather than the ENUM values.

See Section 11.2.1.4, “Functions and Operator Limitations”.

What's Next

• Learn how to perform the following tasks:

  • Run queries

  • Modify tables

  • Retrieve MySQL HeatWave Metadata

  • Optimize workloads for OLAP and OLTP

  • Monitor MySQL HeatWave processes