MySQL HeatWave network layer optimizations have improved scalability and network performance. (WL #14513)

Data loaded into MySQL HeatWave, including propagated changes, are now persisted to OCI Object Storage for recovery in case of a MySQL HeatWave node or cluster failure. Previously, data was recovered from the MySQL DB System. Loading data from OCI Object Storage is faster because data does not need to be converted to the MySQL HeatWave storage format, as is required when loading data from the MySQL DB System. If data recovery from OCI Object Storage fails, MySQL HeatWave falls back to recovering data from the MySQL DB System. Data removed from MySQL HeatWave when a table is unloaded is removed from OCI Object Storage in a background operation. For related information, see MySQL HeatWave Cluster Failure and Recovery. (WL #14478, WL #14046, WL #14541)

MySQL HeatWave now supports COUNT(NULL), except in cases where it is used as an input argument for non-aggregate operators. (Bug #33005146)

Full support was added for the DISTINCT modifier. Previously, multiple instances of (DISTINCT value) expressions in a query were only permitted if the same value was specified. (Bug #32865043, Bug #33007714, WL #14574)

MySQL HeatWave now supports the WITH ROLLUP modifier in GROUP BY clauses. (WL #14533)

MySQL HeatWave now supports window functions. For optimal performance, window functions in MySQL HeatWave utilize a massively parallel, partitioning-based algorithm. For more information, see Window Functions. (WL #14674)