Version information

Information	Description
Release date	Jun 15, 2023
Version	V4.1.0_CE_BP2
Commit number	43bca41

About this version

• This version includes compatibility with MySQL's SHOW CREATE TABLE statement to meet the needs of related tools.
• User and internal testing issues are also addressed to improve version stability.

Fixed issues

• Fixed an issue where querying the TABLE_CONSTRAINTS view would fail when the system variable lower_case_table_names was set to 0.
• Fixed an issue where refreshing the schema after system restart with a large number of partitions caused Proxy to hang when establishing a connection.
• Fixed an issue where data write operations reported error 4017 due to reference count leakage after inserting over 1 billion rows into an unpartitioned table with no primary key.
• Fixed an issue where large transactions involving full table updates continued to report error 4138.
• Fixed compatibility issues with the ObDDLStartLog structure that could cause failures when upgrading from V4.0.0_CE and V4.0.0_CE_BP1 to later versions.
• Fixed an issue where excessive memory was used by SQL Audit during cluster data playback after restart.
• Fixed an issue where abnormal column equal encoding resulted in data exceptions.
• Fixed an issue where core dump might be triggered when timezone info is modified concurrently.
• Added support for complete compatibility with MySQL's SHOW CREATE TABLE statement by setting the session variable _show_ddl_in_compat_mode.

Considerations

• If you are using V4.0.0_CE or V4.0.0_CE_BP1, we recommend that you upgrade directly to V4.1.0_CE_BP2 to avoid possible log playback compatibility issues during the upgrade process.

• If you have unpartitioned tables with large amounts of data and no primary keys, we recommend that you upgrade directly to V4.1.0_CE_BP2 to avoid potential errors that may occur during data write operations.

版本信息

项目	描述
发布日期	2023-06-15
版本号	V4.1.0_CE_BP2
Commit 号	43bca41

发版目的

• SHOW CREATE TABLE 兼容 MySQL 以满足周边工具需求。
• 解决用户及内部测试遇到的问题，提升版本稳定性。

BUG 修复

• 修复系统变量 lower_case_table_names 设置为 0 时，查询 TABLE_CONSTRAINTS 视图失败的问题。
• 修复分区数特别多的场景下，宕机重启后刷新 Schema 较慢导致 Proxy 建立链接卡住的问题。
• 修复无主键表单分区累计插入 10 亿多行数据后，引用计数泄漏导致的数据写入操作报 4017 错误的问题。
• 修复全表更新的大事务场景下，持续报 4138 错误的问题。
• 修复 V4.0.0_CE 和 V4.0.0_CE_BP1 版本升级到后续版本时，由于 ObDDLStartLog 结构体的兼容性问题，可能导致的升级失败问题。
• 修复重启集群数据回放时，SQL Audit 占用内存不合理的问题。
• 修复列间等值编码异常导致的数据异常问题。
• 修复了并发修改 timezone info 可能触发的 core 问题。
• 支持通过设置 Session 变量 _show_ddl_in_compat_mode，使 SHOW CREATE TABLE 返回信息与 MySQL 完全兼容。

注意事项

• 建议在使用 V4.0.0_CE 或 V4.0.0_CE_BP1 版本的用户直接升级到 V4.1.0_CE_BP2 版本，以避免在升级过程中可能出现的日志回放兼容性问题。
• 建议存在无主键表单分区表且数据量较大的用户，直接升级到 V4.1.0_CE_BP2 版本，以避免在写入数据时可能出现的报错问题。