2.27 Changes in MySQL HeatWave 8.2.0 (2023-10-25)

MySQL HeatWave Guided Load reduces the number of steps to manually load data, see Load Data Manually. (WL #15811)
MySQL HeatWave now supports the following string functions:
These functions do not support ENUM type columns, see Data Type Limitations. (WL #15628)
MySQL HeatWave now supports full-table aggregation and group-by support for the following temporal data types:
MySQL HeatWave now supports the following functions with temporal data types:
See: Aggregate Functions. (WL #15637)
MySQL HeatWave now enables the internal conversion of values from one data type to another, including all combinations of these different encodings:
- Numeric values INTEGER, FLOAT, and DECIMAL.
- String values, excluding dictionary-encoded strings.
- Temporal values DATE, TIME, DATETIME, and YEAR data types.
This now permits MySQL HeatWave to offload queries that contain functions with unexpected data types by adding an internal cast from the unexpected data type to an expected data type. (WL #15465)