MySQL 连接器/ODBC 发行说明  / MySQL 连接器/ODBC 版本 8.0 中的更改  /  HeatWave 8.0.23-u1 的变化（2021-02-09，全面上市）

HeatWave 8.0.23-u1 的变化（2021-02-09，全面上市）

添加或更改的功能

  • TEXT为-type 列 添加了字符串列编码支持 。请参阅 编码字符串列。

  • UNION并UNION ALL 扩大了支持范围。现在在 MySQL 允许的查询中的任何位置都支持这些子句。

  • 现在支持以下日期和时间函数：

    请参阅日期和时间函数。

    VARLEN-encoded 列 现在支持以下日期和时间函数 ：

    请参阅日期和时间函数。

    VARLEN-encoded 列 现在支持以下字符串函数 ：

    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 HeatWave Performance Schema Tables.