Release 3.21.06.0

Release Notes:

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

Features:

• [#2636] Support dynamically changing the size of the thread pool. For More Detail, see doc.
• [#2646] Support Mariadb's driver setting useBatchMultiSend. For More Detail, see mariadb doc.
• [#2751] Observe the utilization of SQL statistics queues. For More Detail, see doc.
• [#2713] Support XA transaction residue inspection. For More Detail, see doc.
• [#2408] Sharding routing cannot correctly route to the correct sharding database at "left join" and "union all", thanks to @prostranger for reporting the improvement.
• [#2130][#2676]Provides a switch that determines whether inSubquery would be transformed to join, thanks to @LavieZhou for reporting the improvement.
• [#2641] Upgrade druid to version 1.2.6.
• [#2648] Refactor cluster data. Need to re-create[backup-delete-create] the data for the upgrade.

Bug-fixes:

• [#2622] set autocommit didn't work as expected.
• [#2638] Keep slow log on, dble may occur oom.
• [#2819] The transaction fails problem when using RW-Split, thanks to @boying52 for reporting the bug.
• [#2728] Check table consistency problem, thanks to @lenovore for reporting the bug.
• Sometimes complex queries may cause thread leaks.
• When group by contains =, the result may error.
• jumpStringHash‘s default setting changed, need to reset for the upgrade.
• Some NullPointException.

Breaking backward compatibility:

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

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

---

发行说明：

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

特性：

• [#2636] 支持动态更改线程池大小。更多详细信息，请参见 doc。
• [#2646] 支持 Mariadb 的驱动设置 useBatchMultiSend。更多详细信息，请参阅 mariadb 文档。
• [#2751] 观察 SQL 统计队列的利用率。更多详情见doc。
• [#2713] 支持 XA 事务的残留检查。更多详细信息，请参见 doc。
• [#2408] 分片路由无法在“left join”和“union”处正确路由到正确的分片数据库，感谢@prostranger 报告改进。
• [#2130][#2676] 提供了一个开关，决定是否将 inSubquery 转换为 join，感谢@LavieZhou 报告改进。
• [#2641] 将druid升级到 1.2.6 版。
• [#2648] 重构集群数据。如果升级需要重新创建[备份-删除-创建]数据

缺陷修复:

• [#2622] set autocommit 没有按预期工作。
• [#2638] 开着慢日志，dble可能会出现oom。
• [#2819] 使用读写分离时的事务失败问题，感谢 @boying52 报告错误。
• [#2728] 检查表一致性问题，感谢@lenovore 报告错误。
• 有时复杂的查询可能会导致线程泄漏。
• 当 group by 包含 = 时，结果可能会出错。
• jumpStringHash 的默认设置已更改,升级需要重新设置。
• 一些 NullPointException。

和旧版本的不兼容项：

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

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