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:

  • TO_SECONDS()

  • UNIX_TIMESTAMP()

  • FROM_UNIXTIME()

  • TIME_TO_SEC()

  See Temporal Functions.

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

  • TO_DAYS()

  • DAYOFYEAR()

  • QUARTER()

  • TO_SECONDS()

  See Temporal Functions.

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

  • ORD()

  • ASCII()

  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)