升级说明
* 支持 OceanBase 数据库 V4.1.0_CE 版本在线升级到 OceanBase 数据库 V4.2.0_CE_Beta 版本。
* 不支持从 OceanBase 数据库 V3.x 版本在线升级到 OceanBase 数据库 V4.2.0_CE 版本。
* 支持通过 OMS 将 OceanBase 数据库 V3.x 版本数据使用逻辑迁移升级到 OceanBase 数据库 V4.2.0_CE 版本。
注意事项
* 该版本不建议打开 RPC SSL，相关问题会在后续版本优化。
* 对于 GB18030 到 GB18030-2022 字符集的升级，需要进行逻辑升级。
v4.1.0_CE_BP2
Version information
| **Information** | **Description** |
| ------ | ------ |
| Release date | Jun 15, 2023 |
| Version | V4.1.0_CE_BP2 |
| Commit number | [43bca41](https://github.com/oceanbase/oceanbase/commit/43bca414d5065272a730c92a645c3e25768c1d05) |
| OBServer RPM version | oceanbase-ce-4.1.0.1-102000042023061314 |
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](https://github.com/oceanbase/oceanbase/commit/a30ba89456ccaac2c4d7e43f183f2e3beef1712a).
* [Fixed an issue where refreshing the schema after system restart with a large number of partitions caused Proxy to hang when establishing a connection](https://github.com/oceanbase/oceanbase/commit/2fd14b0cb0d40c8bab7ede48c6fdc96275778a40).
* [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](https://github.com/oceanbase/oceanbase/commit/6997f794527dd385dbcfe28aac2c04e7b750f5c6).
* [Fixed an issue where large transactions involving full table updates continued to report error 4138](https://github.com/oceanbase/oceanbase/commit/f47c10d8d6b23436e0e07772d95a5436e2531eeb).
* [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](https://github.com/oceanbase/oceanbase/commit/443e56bbbb268c375c1a43283d3d5771012d81c4).
* [Fixed an issue where excessive memory was used by SQL Audit during cluster data playback after restart](https://github.com/oceanbase/oceanbase/commit/b317755dde43c5b36987d20f3cc0390da7a93994).
* [Fixed an issue where abnormal column equal encoding resulted in data exceptions](https://github.com/oceanbase/oceanbase/commit/47f00f5f29bb9cdbafca0df972ced62550e3c0b6).
* [Fixed an issue where core dump might be triggered when `timezone info` is modified concurrently](https://github.com/oceanbase/oceanbase/commit/8f52acadce29b59355f646ba0dafe83dc1d9a993).
* [Added support for complete compatibility with MySQL's `SHOW CREATE TABLE` statement by setting the session variable `_show_ddl_in_compat_mode`](https://github.com/oceanbase/oceanbase/commit/ea74ce2deffaaef92ea61841c58905c3e4e62bd7).
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](https://github.com/oceanbase/oceanbase/commit/43bca414d5065272a730c92a645c3e25768c1d05) |
| OBServer RPM 版本号 | oceanbase-ce-4.1.0.1-102000042023061314 |
发版目的
* SHOW CREATE TABLE 兼容 MySQL 以满足周边工具需求。
* 解决用户及内部测试遇到的问题，提升版本稳定性。
BUG 修复
* [修复系统变量 `lower_case_table_names` 设置为 0 时，查询 `TABLE_CONSTRAINTS` 视图失败的问题](https://github.com/oceanbase/oceanbase/commit/a30ba89456ccaac2c4d7e43f183f2e3beef1712a)。
* [修复分区数特别多的场景下，宕机重启后刷新 Schema 较慢导致 Proxy 建立链接卡住的问题](https://github.com/oceanbase/oceanbase/commit/2fd14b0cb0d40c8bab7ede48c6fdc96275778a40)。
* [修复无主键表单分区累计插入 10 亿多行数据后，引用计数泄漏导致的数据写入操作报 4017 错误的问题](https://github.com/oceanbase/oceanbase/commit/6997f794527dd385dbcfe28aac2c04e7b750f5c6)。
* [修复全表更新的大事务场景下，持续报 4138 错误的问题](https://github.com/oceanbase/oceanbase/commit/f47c10d8d6b23436e0e07772d95a5436e2531eeb)。
* [修复 V4.0.0_CE 和 V4.0.0_CE_BP1 版本升级到后续版本时，由于 ObDDLStartLog 结构体的兼容性问题，可能导致的升级失败问题](https://github.com/oceanbase/oceanbase/commit/443e56bbbb268c375c1a43283d3d5771012d81c4)。
* [修复重启集群数据回放时，SQL Audit 占用内存不合理的问题](https://github.com/oceanbase/oceanbase/commit/b317755dde43c5b36987d20f3cc0390da7a93994)。
* [修复列间等值编码异常导致的数据异常问题](https://github.com/oceanbase/oceanbase/commit/47f00f5f29bb9cdbafca0df972ced62550e3c0b6)。
* [修复了并发修改 `timezone info` 可能触发的 core 问题](https://github.com/oceanbase/oceanbase/commit/8f52acadce29b59355f646ba0dafe83dc1d9a993)。
* [支持通过设置 Session 变量 `_show_ddl_in_compat_mode`，使 SHOW CREATE TABLE 返回信息与 MySQL 完全兼容](https://github.com/oceanbase/oceanbase/commit/ea74ce2deffaaef92ea61841c58905c3e4e62bd7)。
注意事项
* 建议在使用 V4.0.0_CE 或 V4.0.0_CE_BP1 版本的用户直接升级到 V4.1.0_CE_BP2 版本，以避免在升级过程中可能出现的日志回放兼容性问题。
* 建议存在无主键表单分区表且数据量较大的用户，直接升级到 V4.1.0_CE_BP2 版本，以避免在写入数据时可能出现的报错问题。
v3.1.5_CE_HF1
Version information
| **Information** | **Description** |
| ------ | ------ |
| Release date | Jun 19, 2023 |
| Version | V3.1.5_CE_HF1 |
| Commit number | [b4c6e7b](https://github.com/oceanbase/oceanbase/commit/b4c6e7b084f2932ff3c21844c915fbf9ba423e69) |
| OBServer RPM version | oceanbase-ce-3.1.5-100010012023060910 |
About this version
This version fixes some bugs and improves stability.
Fixed issues
* [Fixed an issue that the `PARAM INFO` field of the `__all_virtual_plan_stat` table was not deeply copied, which resulted in the generation of a core dump file in the case of access to an invalid memory address](https://github.com/oceanbase/oceanbase/commit/830b1e3d76b2dfd0018a13e1544d770b1162e742).
* [Fixed an issue where an excessive number of rows were returned by the TABLE LOOKUP operator in the table access by index primary key operation, which resulted in the generation of a core dump file in the case of access to an invalid memory address](https://github.com/oceanbase/oceanbase/commit/ba878712ec801e042341f64d3ad4f983e251337d).
* [Fixed an issue where partition pruning was not supported when a time type column was used as a partitioning key and the query condition was not an equation](https://github.com/oceanbase/oceanbase/commit/bd8cb918f090d2ddf636c4933122daa5cc266e68).
版本信息
| **项目** | **描述** |
| ------ | ------ |
| 发布日期 | 2023-06-19 |
| 版本号 | V3.1.5_CE_HF1|
| Commit 号 | [b4c6e7b](https://github.com/oceanbase/oceanbase/commit/b4c6e7b084f2932ff3c21844c915fbf9ba423e69) |
| OBServer RPM 版本号 | oceanbase-ce-3.1.5-100010012023060910 |
发版目的
本次发版主要是 BUG 修复，提升版本稳定性。
BUG 修复
* [修复 `__all_virtual_plan_stat` 中 `PARAM INFO` 字段没有进行深拷贝，导致后续访问非法内存地址 core 掉的问题](https://github.com/oceanbase/oceanbase/commit/830b1e3d76b2dfd0018a13e1544d770b1162e742)。
* [修复 TABLE LOOKUP 的回表行数过多，导致重试过程中访问非法内存地址 core 掉的问题](https://github.com/oceanbase/oceanbase/commit/ba878712ec801e042341f64d3ad4f983e251337d)。
* [修复了时间类型非等值条件的分区裁剪问题，增强了分区裁剪的功能](https://github.com/oceanbase/oceanbase/commit/bd8cb918f090d2ddf636c4933122daa5cc266e68)。
v4.1.0_CE_BP1_HF1
Version information
| **Information** | **Description** |
| ------ | ------ |
| Release date | May 19, 2023 |
| Version | V4.1.0_CE_BP1_HF1 |
| Commit number | [f7379b2](https://github.com/oceanbase/oceanbase/commit/f7379b26f8cd11f026e06846043550f9e0d42ead) |
| OBServer RPM version | oceanbase-ce-4.1.0.0-101010022023051821 |
About this version
This version fixes some bugs and improves stability.
Fixed issues
* [Fixed the data exceptions caused by inter-column equidistant encoding.]()
* [Fixed the possible data write failures caused by `tablet_id` change in the `TRUNCATE TABLE` scenario.]()
版本信息
| **项目** | **描述** |
| ------ | ------ |
| 发布日期 | 2023-05-19 |
| 版本号 | V4.1.0_CE_BP1_HF1|
| Commit 号 | [f7379b2](https://github.com/oceanbase/oceanbase/commit/f7379b26f8cd11f026e06846043550f9e0d42ead) |
| OBServer RPM 版本号 | oceanbase-ce-4.1.0.0-101010022023051821 |
发版目的
本次发版主要是 BUG 修复，提升版本稳定性。
BUG 修复
* [修复列间等值编码异常导致的数据异常问题]()。
* [修复 `TRUNCATE TABLE` 场景下，`tablet_id` 变化可能导致的数据写入失败问题]()。
v4.1.0_CE_BP1
Version information
| **Information** | **Description** |
| --- | --- |
| Release date | May 12, 2023 |
| Version | V4.1.0_CE_BP1 |
| Commit number | [bd50a54](https://github.com/oceanbase/oceanbase/commit/bd50a54ac52a82c5cd3b100781d5ed252822ccd0) |
| OBServer RPM version | oceanbase-ce-4.1.0.0-101000022023050809 |
About this version
This version fixes some bugs and improves stability.
Fixed issues
* [Fixed an issue where the error code of the REGEXP BINARY expression was incompatible with that of MySQL](https://github.com/oceanbase/oceanbase/commit/c1ac596d14e4a6a686b5d96568ed2b2de4cb9443).
* [Fixed a bug where the SQL execution result sets were duplicated after IN expression optimization](https://github.com/oceanbase/oceanbase/commit/bb8666f998f70137b792b1f972f274dfdcc47703).
* [Fixed a bug where OceanBase Database deployed in a Kubernetes cluster failed to start due to too many virtual network cards](https://github.com/oceanbase/oceanbase/commit/4c09570860f5630e421d9b4ea56b5b1ad14556be).
* [Fixed a bug where the execution plan was not generated as expected after an index was created on a generated column and used for table access](https://github.com/oceanbase/oceanbase/commit/1611a5cfb96b3e2a4324405fb124b6d5c4a6329a).
* [Fixed an issue that OceanBase Database does not support the NULLABLE field in the `information_schema.STATISTICS` view](https://github.com/oceanbase/oceanbase/commit/2d5fc3dac5f26234cdbf6cd3af095fe77406085f).
* [Fixed a bug where plan cache eviction would fail if an SQL execution plan occupies too much memory and contains expressions that cannot be parameterized](https://github.com/oceanbase/oceanbase/commit/6f484aac8197f2dd6ac2ffed31c255c0e4cead2a).
* [Fixed a bug related to encoding data estimation error, which resulted in the writing of more than 2 MB of encoded data into the macroblock memory buffer. This bug would result in macroblock serialization failure, which in turn caused the major compaction to be stuck](https://github.com/oceanbase/oceanbase/commit/73d54e913e4c419cba3eb108e9296d923adb9b2a).
Notes
OBD V2.1.0 and later support the upgrade of OceanBase Database from V4.0.0 to V4.1.0.
版本信息
| **项目** | **描述** |
| --- | --- |
| 发布日期 | 2023-05-12 |
| 版本号 | V4.1.0_CE_BP1|
| Commit 号 | [bd50a54](https://github.com/oceanbase/oceanbase/commit/bd50a54ac52a82c5cd3b100781d5ed252822ccd0) |
| OBServer RPM 版本号 | oceanbase-ce-4.1.0.0-101000022023050809 |
发版目的
本次发版主要是 BUG 修复，提升版本稳定性。
缺陷修复
* [修复 REGEXP BINARY 返回错误码与 MySQL 不兼容问题](https://github.com/oceanbase/oceanbase/commit/c1ac596d14e4a6a686b5d96568ed2b2de4cb9443)。
* [修复 In Expr 优化导致的 SQL 执行结果集重复问题](https://github.com/oceanbase/oceanbase/commit/bb8666f998f70137b792b1f972f274dfdcc47703)。
* [修复 k8s 部署集群，因为虚拟网卡太多导致启动失败问题](https://github.com/oceanbase/oceanbase/commit/4c09570860f5630e421d9b4ea56b5b1ad14556be)。
* [修复生成列添加索引后，通过索引访问表，生成执行计划不符合预期问题](https://github.com/oceanbase/oceanbase/commit/1611a5cfb96b3e2a4324405fb124b6d5c4a6329a)。
* [修复 `information_schema.STATISTICS` 视图中 NULLABLE 字段不兼容问题](https://github.com/oceanbase/oceanbase/commit/2d5fc3dac5f26234cdbf6cd3af095fe77406085f)。
* [修复 SQL 执行计划占用内存较大且包含不能参数化的表达式，导致 Plan Cache 无法淘汰问题](https://github.com/oceanbase/oceanbase/commit/6f484aac8197f2dd6ac2ffed31c255c0e4cead2a)。
* [修复编码数据估算误差，导致写入宏块内存 buffer 的编码数据超过 2M，宏块序列化失败，从而产生合并卡住的问题](https://github.com/oceanbase/oceanbase/commit/73d54e913e4c419cba3eb108e9296d923adb9b2a)。
注意事项