Release 3.20.10.0

We have released a new version 3.20.10.0.
Firstly, we must thanks to the following people for their contributions to our community：
@sunshinecb, @13611582598, @lcg72 .

Release Notes:

Features:

• [#1987] Add schema dble_information visited from manager port to use DQL to show dble status. More Detail,see dble_information
• [#2075] Support read and write separation without sharding (alpha version). More Detail,see RW_Split
• [#1987] Support more whiteIP format. More Detail,see whiteIP
• [#2013] Support flushing the connection pool use manager command. More Detail,see fresh_conn
• [#2015] Support setting clientFoundRows capabilities in config or commands. More Detail,see cap_client_found_rows

Bug-fixes:

• [#2225] Expect to send statement 'select ... from table for update' to master.
• [#2042] Explain result may error when the or condition is in the and condition.
• [#1851] Sharding_table in view will cause file import from split to fail.
• [#2180] When dble function conversion contains utf8, the result is incorrect.
• [#2024] Jdbc batch insert error because use PreparedStatement.clearBatch() and conn.commit(), thanks to @sunshinecb for reporting the bug.
• [#1839] select hang when after set session transaction isolation.
• [#2166] Failed to execute split caused by semicolon in the string.
• [#1855] Navicat15 connection dble error, thanks to @lcg72 for reporting the bug.
• [#2158] Simple query with type conversion, it will report "find no Route".
• [#2143] When the fragment field is of decimal type, the query result may be garbled.
• [#1997] Sharding value is a string type, but inside quotes is a hex type, dble will report an error.
• [#1924] The SQL ALTER TABLE O_ORG COMMENT = is not supported. Thanks to @13611582598 for reporting the bug.
• [#2063] When the subquery is listed as * and is a union query, create a view will occur exceptions.
• [#2135] Drop view failed if view name contains schema name.
• [#1994] When alias contains quota, dble report "can't find column" error.
• [#2147] Select ... information_schema.columns ...; will throw an exception when querying with the alias.
• [#2153] In SQL "select ...", when partition column value in "where" is equal to "", causes it to be routed to all nodes.
• [#2026] minus is not supported in dble in fact and need a return error.
• [#2112] When connectionTimeout=30 and manager cmd execute, the real timeout is more than 5min.
• [#2073] execute SQL: "select id,c from test_shard group by c having id<=1 or c ='bb';" will cause NPE.
• [#2162] Insert ...select left join is not supported.
• [#1806] set multi-user-variables result may not correct.
• [#2108] Can not drop view in vertical mode schema.
• [#1961] "show database "statement needs a stricter inspection.

Breaking backward compatibility:

• [#2031] remove command ”rollback“ from manager port

---

我们发布了新版本 3.20.10.0.。
首先，我们必须感谢以下人士对我们社区的贡献：
@sunshinecb, @13611582598, @lcg72

发行说明：

特性：

• [#1987]添加可以从管理端口访问的 schema dble_information, 可以用DQL来查看dble状态。参考文档 dble_information
• [#2075]支持不分库分表的读写分离（alpha功能）。参考文档 RW_Split
• [#1987]支持更多whiteIP格式。参考文档whiteIP
• [#2013]支持刷新连接池使用管理端命令。参考文档 fresh_conn
• [#2015]支持在配置或命令中设置clientFoundRows功能。参考文档 cap_client_found_rows

缺陷修复:

• [#2225]期望将语句“select ... from table for update”发送给主服务器。
• [#2042]当and条件里面嵌套or条件，explain结果可能错误。
• [#1851]视图中的Sharding_table将导致从split导入文件失败。
• [#2180]当dble函数转换包含utf8时，结果不正确。
• [#2024] 使用PreparedStatement.clearBatch（）和conn.commit（）时，Jdbc批处理插入错误。感谢@sunshinecb报告此错误。
• [#1839] 设置会话事务隔离级别后，“ select” 可能会hang。
• [#2166] 字符串中包含分号，会导致无法执行split。
• [#1855] Navicat15连接dble会报错，感谢@ lcg72报告了该错误。
• [#2158] 使用了类型转换的简单查询，会报找不到路由。
• [#2143] 当分片字段为十进制类型时，查询结果可能为乱码。
• [#1997] 分片值是字符串类型，但引号内是十六进制类型，dble将报告错误。
• [#1924] 不支持SQLALTER TABLE O_ORG COMMENT =。感谢@ 13611582598报告此错误。
• [#2063] 当子查询列为*并且是联合查询时，创建视图将发生异常。
• [#2135] 如果视图名称包含schema名称，则删除视图失败。
• [#1994] 当别名包含单引号时，dble报告“找不到列”错误。
• [#2147] 当使用别名查询时，Select ... information_schema.columns ...;将引发异常。
• [#2153] 在“select ...中，当“where”中的分区列值等于“”时，则会将其路由到所有节点。
• [#2026] dble实际上不支持minus，并且需要返回错误。
• [#2112] 当connectionTimeout = 30并且执行manager cmd时，实际超时超过5分钟。
• [#2073] 执行sql：“select id,c from test_shard group by c having id<=1 or c ='bb';“ 将导致NPE
• [#2162] 不支持Insert ...select left join。
• [#1806] 设置多用户变量并且用户变量之间有依赖，结果会不正确。
• [#2108] 无法在垂直模式的schema中删除视图。
• [#1961] “show database”声明需要更严格的检查。

打破向后兼容性：

• [#2031]从管理端移除rollback命令

Release 3.20.07.2

We have released a bug fixed version 3.20.07.2.

Release Notes:

Bug-fixes:

• Garbled characters may exist when some data contains Chinese
• Optimize multi-sharding table left join global table
• reload @@config_all may causes NPE
• Some bugs about enable dbGroup
• The column size in show @@dbInstance
• sqlMaxLimit of table is not work
• Some bugs about cluster

我们发布了3.20.07.2..这是个基于3.20.07.1的bug修复版本

发行说明：

问题修复:

• 修复一些行数据为中文时候可能存在的乱码
• 分片表多层left join 全局表无法整体下发
• reload @@config_all 可能返回NPE
• 高可用命令的一些bug
• show @@dbInstance中的size列值显示成了minCon，期望显示maxCon
• 表级别的sqlMaxLimit未生效
• 集群的一些问题

Release 2.20.04.4

We have released a bug fixed version 2.20.04.4.

Release Notes:

Bug-fixes:

• Garbled characters may exist when some data contains Chinese
• Optimize multi-sharding table left join global table
• reload @@config_all may causes NPE

我们发布了2.20.04.4..这是个基于2.20.04.3的bug修复版本

发行说明：

问题修复:

• 修复一些行数据为中文时候可能存在的乱码
• 分片表多层left join 全局表无法整体下发
• reload @@config_all 可能返回NPE

Release 2.19.11.4

We have released a bug fixed version 2.19.11.4.

Release Notes:

Bug-fixes:

• Garbled characters may exist when some data contains Chinese
• Optimize multi-sharding table left join global table

我们发布了2.19.11.4..这是个基于2.19.11.3的bug修复版本

发行说明：

问题修复:

• 修复一些行数据为中文时候可能存在的乱码
• 分片表多层left join 全局表无法整体下发

Release 3.20.07.1

We have released a bug fixed version 3.20.07.1.

Release Notes:

Bug-fixes:

• some problems of XA
• some problems of split
• case...when problems of Chinese
• issue #2073
• issue #2158

我们发布了3.20.07.1..这是个基于3.20.07.0的bug修复版本

发行说明：

问题修复:

• 复杂查询的一些问题
• split功能的一些问题
• case...when列包含中文的一些问题
• issue #2073
• issue #2158

Release 2.20.04.3

We have released a bug fixed version 2.20.04.3.

Release Notes:

Bug-fixes:

• some problems of XA
• some problems of split
• case...when problems of Chinese
• issue #2073

我们发布了2.20.04.3..这是个基于2.20.04.2的bug修复版本

发行说明：

问题修复:

• 复杂查询的一些问题
• split功能的一些问题
• case...when列包含中文的一些问题
• issue #2073

Release 2.19.11.3

We have released a bug fixed version 2.19.11.3.

Release Notes:

Bug-fixes:

• some problems of XA
• some problems of split
• case...when problems of Chinese

我们发布了2.19.11.3..这是个基于2.19.11.2的bug修复版本

发行说明：

问题修复:

• 复杂查询的一些问题
• split功能的一些问题
• case...when列包含中文的一些问题

Release 3.20.07.0

We have released a new version 3.20.07.0.
Firstly, we must thanks to the following people for their contributions to our community：
@dairight, @z3093964447.

Release Notes:

Features:

• [#1879] Refactor code for connection pool
• [#1863] Support more DML queries which can be pushed down to MySQL directly. More Detail,see 3.SQL_Syntax/3.2_DML
• [#1849] Refactor config files:There are big changes for config files of dble, More Detail,see 1.00_config_file . If you want to upgrade your old configs(must be 2.20.04.x) to new configs， you can use the tool named dble_update_config. .
• [#1848] Support online ddl. More Detail,see online_ddl
• [#1846] send query by WriteToBackendExecutor in complex query
• [#1906] Supports the tool OGG for data synchronization (alpha)

Bug-fixes:

• [#2030] Execute a complex SQL which contains many unions but hang
• [#2029] Occur error"field not found:c.成功一" when the column name contains Chinese
• [#2025] Error when there is constant in select
• [#2022] Round function have problem
• [#2021] After multiple unions and subqueries, the column order is incorrect
• [#1977] The query needs to be printed in the log，when management commands not supported
• [#1939] When PreparedStatement is enabled, multiple insert operations on tables containing data types such as blob、text; the inserted value contains the value of the previous SQL insert/update.
• [#1926] If sharding value is a hex type,dble will report error or route to the wrong node
• [#1913] When two sharding_table inner join , the select DATEDIFF() result is different from one table select DATEDIFF()
• [#1820] JDBC has problems saving pictures via setblob or setBinaryStream , thanks to @z3093964447 for reporting the bug.
• [#1814] When load data failed,the file:temp was left behind
• [#1788] Front connect timeout,may cause heartbeat detection to fail
• [#1760] Contaminate mysql connection pool when doing ddl in xa transaction
• [#1701] Expect the default xa log name and xa log directoty name contain 'xa'
• [#1678] Column name of [show tables] resultset is not consistent with mysql
• [#1658] When tempReadHostAvailable="1",show slave status not work, thanks to @dairight for reporting the bug.

Breaking backward compatibility:

• [#1849] Refactor config files:There are big changes for config files of dble, More Detail,see 1.00_config_file . If you want to upgrade your old configs(must be 2.20.04.x) to new configs by the tool.

我们发布了新版本3.20.07.0.。
首先，我们必须感谢以下人士对我们社区的贡献：
@dairight, @z3093964447

发行说明：

特性：

• [#1879]重构连接池的代码
• [#1863]支持更多DML语句可以被直接将其下推到MySQL。更多详细信息，请参见文档3.SQL_Syntax / 3.2_DML
• [#1849]重构配置文件：dble的配置文件有很大变化，更多详细信息，请参见1.00_config_file。如果要将旧的配置(必须为2.20.04.x)升级到新的配置，则可以使用名为“ dble_update_config”的工具。
• [#1848]支持在线ddl. 更多详细信息，请参见online_ddl
• [#1846]通过WriteToBackendExecutor在复杂查询中发送查询
• [#1906] Dble支持OGG工具进行数据同步(alpha功能)

缺陷修复:

• [#2030]执行一个复杂的SQL，其中包含许多并集但会挂起
• [#2029]当列名称包含中文时，发生错误“field not found:c.成功一”
• [#2025]错误，当select中存在常量时
• [#2022]Round函数有问题
• [#2021]多个联合和子查询后，列顺序不正确
• [#1977]不支持管理命令时，需要在日志中打印查询
• [#1939]启用PreparedStatement后，将对包含blob，text等数据类型的表进行多次插入操作；插入的值包含先前SQL插入/更新的值。
• [#1926]如果分片值是十六进制类型，dble将报告错误或路由到错误的节点
• [#1913]当两个sharding_table inner join时，查询DATEDIFF()结果不同于单表查询DATEDIFF()
• [#1820]JDBC在通过setblob或setBinaryStream保存图片时遇到了问题，这要感谢@z3093964447报告此错误。
• [#1814]当“load data”失败时，临时文件未被删除
• [#1788]前端连接超时，可能导致心跳检测失败
• [#1760]在xa事务中执行ddl时污染了mysql连接池
• [#1701]期望默认的xa日志名称和xa日志直接名称包含“ xa”
• [#1678]show tables的结果集列名与mysql不符
• [#1658]当 tempReadHostAvailable =“ 1”，show slave status无法正常切换，这要感谢@dairight报告了该错误。

##打破向后兼容性：

• [#1849]重构配置文件：dble的配置文件有很大变化，更多详细信息，请参见1.00_config_file。如果要将旧的配置(必须为2.20.04.x)升级到新的配置，则可以使用名为“ dble_update_config”的工具。

Release 2.20.04.2

We have released a bug fixed version 2.20.04.2.

Release Notes:

Bug-fixes:

• some problems of XA
• some problems of complex select query

我们发布了2.20.04.2.这是个基于2.20.04.0的bug修复版本

发行说明：

问题修复:

• XA的一些问题
• 复杂查询的一些问题

Release 2.19.11.2

We have released a bug fixed version 2.19.11.2.

Release Notes:

Bug-fixes:

• some problems of left join
• some problems of NPE
• some problems of XA
• some problems of complex select query

我们发布了2.19.11.2.这是个基于2.19.11.1的bug修复版本

发行说明：

问题修复:

• 某些场景下的left join问题
• 某些场景下的NPE问题
• XA的一些问题
• 复杂查询的一些问题