HeatWave Release Notes  /  Changes in HeatWave  /  Changes in HeatWave 8.0.23-u1 (2021-02-09, General Availability)

Changes in 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.

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

  • The following date and time functions are now supported:

    See Date and Time Functions.

    The following date and time functions are now supported with VARLEN-encoded columns:

    See Date and Time 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.

  • 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;
  • New Performance Schema tables provide access to query and execution statistics:

    • performance_schema.rpd_exec_stats

    • performance_schema.rpd_query_stats

    Changes to 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 HeatWave node.

    See Performance Schema Tables.