MySQL HeatWave Release Notes

2.46 Changes in MySQL HeatWave 8.0.23-u1 (2021-02-09, General Availability)

Functionality Added or Changed

  • String column encoding support was added for TEXT-type columns. See Encoding String Columns. (WL #14430)

  • UNION and UNION ALL support was extended. The clauses are now supported at any location in a query that is permitted by MySQL. (WL #14455)

  • The following temporal functions are now supported:

    See Temporal Functions.

    The following temporal functions are now supported with VARLEN-encoded columns:

    See Temporal Functions.

    The following string functions are now supported with VARLEN-encoded columns:

    See String Functions and Operators.

    SET timezone = timezone with the timezone value specified as an offset from UTC in the form of [H]H:MM and prefixed with a + or - is now supported with the UNIX_TIMESTAMP() and FROM_UNIXTIME() functions. (WL #14345)

  • Offset is now supported with the LIMIT clause: 

    SELECT * FROM tbl LIMIT offset,row_count;

    The PostgreSQL syntax is also supported: 

    SELECT * FROM tbl LIMIT row_count OFFSET offset;

    (WL #14341)

  • New Performance Schema tables provide access to query and execution statistics:

    • performance_schema.rpd_exec_stats

    • performance_schema.rpd_query_stats

    Changes to MySQL HeatWave Performance Schema tables:

    • An NDV (Number of Distinct Values) column was added to the performance_schema.rpd_columns table.

    • A ROWS column that shows the total number of rows in a table was added to the performance_schema.rpd_tables table.

    • A MEMORY_USAGE column that shows node memory usage was added to the performance_schema.rpd_columns table.

    • The performance_schema.rpd_nodes DRAM column was renamed to MEMORY_TOTAL. The MEMORY_TOTAL column shows the total memory allocated to a MySQL HeatWave node.

    See MySQL HeatWave Performance Schema Tables. (WL #14386)

MySQL Documentation Library