RELEASE NOTE
Feature enhancement
Support the INSERT INTO TABLENAME() VALUES() syntax.
Support using tableless UNION in the UPDATE SET clause.
Optimize the logic for REPLACE pushdown judgment to support the pushdown of REPLACE statements under Read Committed (RC) isolation level in certain scenarios.
Prohibits the execution of DDLs without specifying a SCHEMA in the INFORMATION_SCHEMA database.
Support physical replication of encrypted tables.
Introduce support for expansion and shrinkage operational windows.
Support specifying KEY_BLOCK_SIZE and other parameters related to table compression when creating tables.
Optimize the execution speed of creating Global Secondary Indexes (GSI) and altering table partition keys.
Support multi-statement modifications in ALTER TABLE to be compatible with MySQL.
Optimize the index selection logic by rejecting Global Secondary Indexes (GSI) that cannot use local indexes for DML operations on a single table.
Eliminate redundant GROUP BY UK.
Enhance the speed and reduces CPU usage for online column type changes on compute nodes.
Improve the performance of statistical estimation for IN expressions in IN Values scenarios.
Bugfix
Fix issue where single-table sample hints in statistical information do not take effect.
Fix issue where OMC 2.0 might cause incorrect routing of existing UGSI data.
Fix issue causing foreign key constraint addition to fail when handling self-referencing table indexes and character set checks.
Fix parsing error when values are too large in LIMIT x, y.
Fix error when migrating ugsi with physical replication enabled.
Fix failure when performing lock-free column changes on single tables and broadcast tables.
Parser disables parsing private DDL in global Binlog Query Event comments to prevent downstream DDL application errors.
Fix issue where MDL lock cleanup during DDL execution could lead to ineffective transaction draining and data inconsistency.
Fix issue where INSERT IGNORE might produce a Duplicate entry error during expansion or shrinkage.
Fix issue in MPP mode where result sets are not closed correctly, leading to backend connections hanging.
Fix incorrect recommendations given by inspect index in certain scenarios.
Fix issue where inner join-outer join reorder may lead to incorrect results.
Fix potential unexpected failure of DDL when auto_increment column contains records with value 0.
Fix issue where upgrading from standard to enterprise edition fails to import metadata if database name ends with s or S.
Fix error when executing DDL with ALTER TABLE REMOVE PARTITIONING combined with options.
Fix issue where port resource swapping in low resource scenarios on storage nodes could lead to misuse of instance-level connection pools with private protocols.
发布说明
特性更新
新增支持INSERT INTO TABLENAME() VALUES() 语法。
新增支持在UPDATE SET子句中使用无表UNION的语法。
优化逻辑REPLACE下推判断，支持RC隔离级别下的部分场景下推REPLACE语句。
禁止在INFORMATION_SCHEMA库中执行不指定SCHEMA的 DDL。
新增物理复制支持加密表。
新增支持扩缩容运维窗。
创建表时新增支持指定KEY_BLOCK_SIZE等与表压缩功能相关的参数配置。
优化创建GSI以及表分区键变更的执行速度。
新增支持alter table兼容MySQL的多语句修改。
优化索引选择的逻辑，对于仅涉及一张表的DML，拒绝使用无法走局部索引的GSI。
优化掉冗余的group by uk。
优化在线列类型变更执行速度以及计算节点CPU占用 情况。
优化IN Values场景下IN表达式统计信息估算的性能。
问题修复
修复统计信息单表sample hint不生效的问题。
修复OMC 2.0可能会导致UGSI存量数据路由错误的问题。
修复在处理自引用表索引及字符集检测时，导致外键约束添加失败的问题。
修复LIMIT x, y当数值过大时解析报错的问题。
修复开启物理复制后迁移ugsi报错的问题。
修复对单表和广播表进行无锁列变更时会执行失败的问题。
Parser关闭解析全局Binlog Query Event中注释的私有DDL，防止下游apply DDL出错。
修复执行DDL时，MDL锁清理存在判断失误导致事务排空失效，引入的数据不一致问题。
修复扩缩容过程中，insert ignore可能出现Duplicate entry报错的问题。
修复MPP模式下结果集没有正确关闭导致后端连接卡死的问题。
修复inspect index在个别场景下给出的建议错误的问题。
修复inner join-outer join reorder可能导致结果不正确的问题。
修复auto_increment列存在值为0的记录时，DDL可能非预期失败的问题。
修复标准版升企业版时，库名以s或S结尾导致导入元数据失败的问题。
修复alter table remove partitioning同时指定option时DDL执行报错的问题。
修复低资源场景下存储节点端口资源互换导致私有协议实例级连接池误用的问题。