Milestones

1. Sharding-Proxy launch. Support the use of Sharding-Sphere in the form of database to support for MySQL CLI and GUI client

New Features

Core

1. ISSUE #290 Support batch INSERT
2. ISSUE #501 Support OR
3. ISSUE #980 Support DCL
4. ISSUE #1111 Support MySQL DAL

Sharding-Proxy

1. ISSUE #902 Support XA transaction
2. ISSUE #916 Support authorization
3. ISSUE #936 Support registry center
4. ISSUE #1046 Support multiple logic databases

Enhancements

Core

1. ISSUE #373 Support order by ?
2. ISSUE #610 Route unicast for DQL without table
3. ISSUE #701 Caching parsed results to improve performance
4. ISSUE #773 Support sharding and autoincrement key of INSERT without column names
5. ISSUE #935 Use YAML instead of JSON to store configurations in registry center
6. ISSUE #1004 Properties can configure for Sharding and Master-slave independent
7. ISSUE #1205 Execute engine enhancement

Sharding-JDBC

1. ISSUE #652 Support Spring Boot Starter 2.X
2. ISSUE #702 Support $->{..} for inline expression
3. ISSUE #719 Support inject key generator objects by spring namespace
4. ISSUE #720 Support inject sharding algorithm objects by spring namespace

Sharding-Opentracing

1. ISSUE #1172 Opentracing enhancement

API changes

1. ISSUE #1153 Adjust the maven artifactId for Orchestration module
2. ISSUE #1203 Adjust Spring namespace xsd for Sharding and Master-slave
3. ISSUE #1289 Adjust Hint API
4. ISSUE #1302 Refine package structure
5. ISSUE #1305 Deprecated and remove sharding-jdbc-transaction-parent module
6. ISSUE #1382 Remove type configuration in Orchestration module

Bug Fixes

Core

1. ISSUE #569 Failed to parse SQL for Oracle when ROWNUM is not at end
2. ISSUE #628 Support data type jsonb for PostgreSQL
3. ISSUE #646 When aliases in SELECT ITEMS correspond to the real column names of GROUP BY or ORDER BY, there is no need to generate derived columns
4. ISSUE #806 NOT IN parse exception
5. ISSUE #827 Endless loop for bad SQL like SELECT * FROM table WHERE id IN ()
6. ISSUE #919 Inline expression with groovy may cause memory leak
7. ISSUE #993 Fail to parsing PostgreSQL due to the quotation
8. ISSUE #1015 Support SQL like SELECT id, COUNT(*) FROM table GROUP BY 1,2
9. ISSUE #1120 Derived columns of GROUP BY / ORDER BY appear in query result
10. ISSUE #1186 Dead lock may occur on MEMORY_STRICTLY mode when get connection on concurrency environment
11. ISSUE #1265 RoundRobinMasterSlaveLoadBalanceAlgorithm throw an ArrayIndexOutOfBoundsException when AtomicInteger overflow

Sharding-JDBC

1. ISSUE #372 Reuse PreparedStatement cause cache of route result do not clean
2. ISSUE #629 Support transaction isolation on JDBC
3. ISSUE #735 Unexpected slave datasource routing result when using Round-robin load-balance algorithm in Mybatis
4. ISSUE #1011 Can't resolve placeholder in Spring Boot YAML configuration

New Features

Core

1. ISSUE #980 Support DCL

Sharding-Proxy

1. ISSUE #916 Support authorization
2. ISSUE #936 Support registry center

Enhancements

Core

1. ISSUE #935 Use YAML instead of JSON to store configurations in registry center
2. ISSUE #1004 Properties can configure for Sharding and Master-slave independent

Bug Fixes

Core

1. ISSUE #919 Inline expression with groovy may cause memory leak
2. ISSUE #1015 Support SQL like SELECT id, COUNT(*) FROM table GROUP BY 1,2

Sharding-JDBC

1. ISSUE #372 Reuse PreparedStatement cause cache of route result do not clean
2. ISSUE #993 Fail to parsing PostgreSQL due to the quotation
3. ISSUE #1011 Can't resolve placeholder in Spring Boot YAML configuration

Milestones

1. Sharding-Proxy launch. Support the use of Sharding-Sphere in the form of database to support for MySQL CLI and GUI client

New Features

1. ISSUE #290 Support batch INSERT statements
2. ISSUE #501 Support OR statement

Enhancements

1. ISSUE #608 Support the USE statement of MySQL
2. ISSUE #609 Support the SHOW statement of MySQL
3. ISSUE #610 Optimize the DQL that does not contain a table name
4. ISSUE #611 Support the DESC statement of MySQL
5. ISSUE #652 Support Spring Boot Starter 2.x
6. ISSUE #701 Support caching parsing results of SQL to improve performance
7. ISSUE #702 Support $->{..} as mark for inline expression
8. ISSUE #719 Support Spring bean namespace to inject key generator objects
9. ISSUE #720 Support Spring bean namespace to inject sharding algorithm objects
10. ISSUE #773 Support sharding and autoincrement primary key of INSERT statements without column names

Bug Fixes

1. ISSUE #628 Support data type jsonb for PostgreSQL
2. ISSUE #629 Support transaction isolation on JDBC
3. ISSUE #646 When aliases in SELECT ITEMS correspond to the real column names of GROUP BY or ORDER BY, there is no need to add columns
4. ISSUE #735 Unexpected slave datasource routing result when using Round-robin load-balance algorithm in Mybatis
5. ISSUE #806 SQL parse error with NOT IN
6. ISSUE #827 Fix endless loop for bad SQL like SELECT * FROM table WHERE id IN ()

功能提升

1. ISSUE #600 支持TCL

缺陷修正

1. ISSUE #522 读写分离Slave库不需要执行DDL语句
2. ISSUE #540 梳理并支持别名为关键字SQL
3. ISSUE #577 支持YAML配置换行