Release | 开源分布式中间件 DBLE 2019 农历年首发！

3月1日，企业级开源分布式中间件DBLE最新版本 2.19.01.0  发布，本次新版新增了一些feature，如新增了docker 镜像、show @@processlist管理命令等功能；主要对reload、查询计划和自增列等进行了优化；修复了一些跨表join和混合类型表join等复杂查询的issue，具体内容及其他相关部分请参考release文档 。

• Add attribute incrementColumn for table #933. For more details, click here

• Add a new command show @@processlist for manager user #975. For more details, click here

• Add filter for reload @@metadata #944. For more details, click here

• Add gc.log in default wrapper.conf

• Add Version attribute in rule/schema/server.xml to help to identify config version

• Add quick start with docker , see Quick Start With Docker or Quick Start With Docker-Compose.

• Do not reload all metadata when reloading config/config_all if no need #946. For more details, click here

• Improve primary key to route result cache #947. For more details, click here

• Add a new command to view in-processing ddl #887. For more details, click here

• Optimize query execution plan :1.global table join nosharding talbe #915 2. where condition statement contains multi statement,but it can route to a special node in fact #801

• Report error if the value of set is not in candidate values in configuration files #576

• If use the RocksDB database engine as a route cache, it does not work #1029

• Error when nested subquery contains not in on global table #1030

• dble should not check “port” configured in myid.properties when use zookeeper as cluster manager #1025

• SubQuery can not correctly executed some complex-query case #1027

• May get NPE when global table join with nosharding table and sharding table #1023

• May report error when two sharding tables cross database #968

• Some of the judgment conditions in the subquery of global table are lost #1022

• Cleaning dble registered keys in zk will make dnindex.properties which is under directory named conf deleted #991

• When testing the stability of dble + lvs, Dble returns to NPE #954

• reload @@config_all gets odds err “java.util.ConcurrentModificationException” #984

• Use incorrect decoder to decode non-ASCII sharding column for utf8mb4 before routing #995

• Error when cross-database join syntax contains global table #965

• [select … from … where …order by convert(col using gbk); ] get ERROR: CONVERT(… USING …) is standard SQL syntax #982, but order is not fixed

• For nosharding table, got error from multiple tables join(the tables come from different databases ) #1001

• Got error while executing the sql “select schema3.test3.id,schema3.test3.pad from schema1.test1 join schema3.test3 where schema1.test1.id=schema3.test3.id and schema3.test3.id =1;” #967

• For global table, in select …where… syntax, now not support “schema.table.column” in where clause #964

• For global table, got error(NoSuchElementException) while executing “select * from schema2.test2 union select * from view_test;” #970

• For no-sharding table, got error while executing sql “show columns in test1” #958

• For global table, the isolation level REPEATABLE READ not work fine #989

• Error when union query contains TRIM(LEADING ‘x’ FROM ‘xxxbarxxx’) and sharding table #953

• [CREATE TABLE test1(id int, data1 int,data2 int,data3 int as (data1+data2) stored);] hang #936

• For manager command: show @@Datasource， now the ACTIVE column show negative number #942

• Query with 2 “in subquery” with global table may get error “ERROR 4004 (42S22): column autoalias_tt.autoalias_scalar not found” #961

• Error when create procedure with hint #919

• Join different default datanode table with same name get wrong resultset #926

• Join same table name and different sharding in different schema get error:Not unique table/alias#865

• show @@sql and show @@sql.resultset returns unstable results #846

• [select 12 as Department, Department from global_table1 group by Department] got error :duplicate column:Department#931

• [select * from mytest.sharding_two t where t.not_sharding_col=2] with case insensitive, will get “table doesn’t exist” #930

• Drop view failed when using keyword as view name view #920

• Use incorrect decoder to decode non-ASCII sharding column for utf8mb4 before routing #995. So if you use character utf8mb4 and use string column as sharding column ,you must re-sharding your data for upgrade.

• Reload config will not reload metadata of all tables #946. For more details, click here

老规矩，先认真阅读Release notes原文，后续我们会分期圈重点，详细解析2.19.01.0 版本新增特性的正确打开方式以及重点issue修复的积极影响。

点击“阅读原文”可直达GitHub～

开源分布式中间件DBLE

社区官网：https://opensource.actionsky.com/

GitHub主页：https://github.com/actiontech/dble

技术交流群：669663113

开源数据传输中间件DTLE

社区官网：https://opensource.actionsky.com/

GitHub主页：https://github.com/actiontech/dtle

技术交流群：852990221