API Changes

1. Adjust persist structure for orchestration's registry center.
2. Adjust Sharding-JDBC configuration API.

New Features

1. XA Transaction available.
2. All SQL 100% compatible if route to single data node (MySQL Only).
3. DISTINCT SQL syntax available.
4. Broadcast table available.
5. Solve data lean problem when using DefaultKeyGenerator with low TPS.

Change Logs

1. MILESTONE #3
2. MILESTONE #4

API changes

1. Adjust persist structure for orchestration's registry center.
2. Adjust Sharding-JDBC configuration API.

New Features

1. XA Transaction available.
2. All SQL 100% compatible if route to single data node (MySQL Only).
3. DISTINCT SQL syntax available.
4. Broadcast table available.
5. Solve data lean problem when using DefaultKeyGenerator with low TPS.

Change Logs for Issues and Pull requests

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配置换行