Changes in MySQL HeatWave 8.0.26-u2 (2021-09-21, General Availability)

Functionality Added or Changed

• The following function support was added:

  • YEARWEEK(date), YEARWEEK(date,mode)

  • The mode argument for the two-argument form of the WEEK() function: WEEK(date[,mode])

  • MAKEDATE()

  • “Zero” handling for dates such as '2001-11-00' was implemented for WEEK(), YEARWEEK(), and MAKEDATE() functions.

  • CAST() of FLOAT and DOUBLE values to DECIMAL

  (Bug #33163625, Bug #33138534, WL #14714)

• The new hw_data_scanned global status variable tracks the total cumulative megabytes scanned by successfully executed MySQL HeatWave queries.

  The number of megabytes scanned by an individual MySQL HeatWave query can be obtained by querying the performance_schema.rpd_query_stats table.

  An estimated number of megabytes scanned by an individual query can be obtained by running the query with EXPLAIN and querying the performance_schema.rpd_query_stats table.

  For more information, see Scanned Data Monitoring. (WL #14738)