Changes in MySQL HeatWave 8.0.24 (2021-04-20, General Availability)

Functionality Added or Changed

• Comparison of different temporal type values is now supported. For example, a query that compares DATE values to TIMESTAMP values can now be offloaded to MySQL HeatWave. (Bug #32420986)

• Range operators on VARLEN-encoded string columns are now supported. For example, the following query, where L_LINESTATUS is a VARLEN-encoded string column, can now be offloaded to MySQL HeatWave:

  SELECT COUNT(*) FROM lineitem WHERE L_LINESTATUS  >= 1 and L_LINESTATUS <= 10;

  (Bug #31721399)

• MySQL HeatWave now supports INSERT ... SELECT statements where the SELECT query is offloaded to MySQL HeatWave and the result set is inserted into a table on the MySQL Database Service instance. This feature improves INSERT ... SELECT performance in cases where the SELECT portion of the statement is a long running, complex query. For more information, see INSERT ... SELECT Statements. (WL #14299)

• VARLEN-encoded columns are now supported as data placement keys. For information about the data placement feature, see Data Placement Keys. (WL #14491)

• Failure handling was improved for queries involving unsupported internal data types. Such queries now exit with an error indicating that the internal data type of the query is not supported. (WL #14483)