Release 3.21.06.0

[yanhuqing666]

Release Notes:

We have released a new version 3.21.06.0.
Firstly, we must thanks to the following people for their contributions to our community：@prostranger, @LavieZhou, @lenovore, @boying52.

Features:

• [[Improve] dynamically adjust the thread pool #2636] Support dynamically changing the size of thread pool. More Detail,see doc.
• [[Improve] frontend processor refactor #2646] Support Mariadb's driver setting useBatchMultiSend. More Detail,see mariadb doc.
• [[Improve]Observe the utilization of SQL statistics queues #2751] Observe the utilization of SQL statistics queues. More Detail,see doc.
• [[Improve] XA transaction residue detection #2713] Support XA transaction residue inspection. More Detail,see doc.
• [sharding routing cannot correctly route to the correct sharding database at "left join" and "union all" #2408] Sharding routing cannot correctly route to the correct sharding database at "left join" and "union all", thanks to @prostranger for reporting the improvement.
• [SQL:select a.* from gtest a where 1=1 and a.id in (select b.id from test b) order by a.id; could not parse subquery first #2130][[Improve] Provides a switch that determines whether inSubquery transform to join #2676]Provides a switch that determines whether inSubquery would be transformd to join, thanks to @LavieZhou for reporting the improvement.
• [[Improve]upgrade from druid 1.2.3 to druid 1.2.6 #2641] Upgrude druid to version 1.2.6.
• [[Improve] cluster refactor #2648] Refactor cluster data. Need to re-create[backup-delete-create] the data if upgrade.

Bug-fixes:

• [set autocommit didn't work out as expected #2622] set autocommit didn't work as expected.
• [Keep slow log on, dble may occur oom #2638] Keep slow log on, dble may occur oom.
• [The transcation fail problem #2819] The transcation fail problem when using RW-Split, thanks to @boying52 for reporting the bug.
• [make start_time in sql_log manager table human readable #2728] Check table consistency problem, thanks to @lenovore for reporting the bug.
• Sometimes complex query may cause thread leak.
• When group by contains =, the result may error.
• jumpStringHash‘s default setting changed, need to reset if upgrade.
• Some NullPointException.

Breaking backward compatibility:

• [[Improve] Provides a switch that determines whether inSubquery transform to join #2676]Provides a switch that determines whether inSubquery would be transformd to join. The default value was true and now is false.
• [[Improve] cluster refactor #2648] Refactor cluster data. Need to re-create[backup-delete-create] the data if upgrade.
• Remove commond like file @@...,show @@syslog.
• jumpStringHash‘s default setting changed, need to reset if upgrade.

If upgrade from the old version to this, you must know this.

---

发行说明：

我们发布了新版本 3.21.06.0。
首先，我们必须感谢以下人士对我们社区的贡献：@prostranger, @LavieZhou, @lenovore, @boying52.

特性：

• [[Improve] dynamically adjust the thread pool #2636] 支持动态更改线程池大小。更多详细信息，请参见 doc。
• [[Improve] frontend processor refactor #2646] 支持 Mariadb 的驱动设置 useBatchMultiSend。更多详细信息，请参阅 mariadb 文档。
• [[Improve]Observe the utilization of SQL statistics queues #2751] 观察 SQL 统计队列的利用率。更多详情见doc。
• [[Improve] XA transaction residue detection #2713] 支持 XA 事务的残留检查。更多详细信息，请参见 doc。
• [sharding routing cannot correctly route to the correct sharding database at "left join" and "union all" #2408] 分片路由无法在“left join”和“union”处正确路由到正确的分片数据库，感谢@prostranger 报告改进。
• [SQL:select a.* from gtest a where 1=1 and a.id in (select b.id from test b) order by a.id; could not parse subquery first #2130][[Improve] Provides a switch that determines whether inSubquery transform to join #2676] 提供了一个开关，决定是否将 inSubquery 转换为 join，感谢@LavieZhou 报告改进。
• [[Improve]upgrade from druid 1.2.3 to druid 1.2.6 #2641] 将druid升级到 1.2.6 版。
• [[Improve] cluster refactor #2648] 重构集群数据。如果升级需要重新创建[备份-删除-创建]数据

缺陷修复:

• [set autocommit didn't work out as expected #2622] set autocommit 没有按预期工作。
• [Keep slow log on, dble may occur oom #2638] 开着慢日志，dble可能会出现oom。
• [The transcation fail problem #2819] 使用读写分离时的事务失败问题，感谢 @boying52 报告错误。
• [make start_time in sql_log manager table human readable #2728] 检查表一致性问题，感谢@lenovore 报告错误。
• 有时复杂的查询可能会导致线程泄漏。
• 当 group by 包含 = 时，结果可能会出错。
• jumpStringHash 的默认设置已更改,升级需要重新设置。
• 一些 NullPointException。

和旧版本的不兼容项：

• [[Improve] Provides a switch that determines whether inSubquery transform to join #2676] 提供一个开关，用于确定是否将 inSubquery 转换为 join。默认行为曾经为 true，现在为 false。
• [[Improve] cluster refactor #2648] 重构集群数据。如果升级需要重新创建[备份-删除-创建]数据。
• 删除诸如file @@...、show @@syslog 之类的命令。
• jumpStringHash 的默认设置已更改，如果升级需要重置。

如果您从旧版本升级升级到本版本，您应该先阅读版本变更的内容.

---

This discussion was created from the release Release 3.21.06.0.