HeatWave Release Notes  /  Changes in HeatWave  /  Changes in HeatWave 8.0.24 (2021-04-20, General Availability)

Changes in 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 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 HeatWave:

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

    (Bug #31721399)

  • HeatWave now supports INSERT ... SELECT statements where the SELECT portion of the statement is offloaded to HeatWave for accelerated execution, and the result set is inserted into a table on the MySQL Database Service instance. Offloading the SELECT query to HeatWave can reduce INSERT ... SELECT statement execution time. For more information, see INSERT ... SELECT Statements.

  • VARLEN-encoded columns are now supported as data placement keys. For information about the data placement feature, see Defining Data Placement Keys.

  • 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.