4.0.0
API Changes
- Change package and maven groupId form
io.shardingsphere
toorg.apache.shardingsphere
. - Adjust Sharding-JDBC configuration API.
- Adjust persist structure for registry center.
New Features
- SQL92 Syntax available.
- Sharding-Proxy for PostgreSQL protocol available.
- SQL 100% compatible if route to single data node.
- Less-than(<), greater-than(>) and Less-than-equal(<=), greater-than-equal(>=) for sharding key operator available.
- DISTINCT SQL syntax available.
- Broadcast table available.
- LEAF key generator available.
- XA Transaction available, Atomikos, Narayana and Bitronix integrated.
- BASE Transaction available, Seata integrated.
- Data encrypt available.
- Skywalking plugin available.
- Sharding-UI available, an orchestration management platform.
Enhancement
- MariaDB supported.
- Improve the compatibility of SQL parsing.
SELECT FOR UPDATE
route to master data source only.- Hint in Sharding-Proxy available.
- Make configuration of orchestration consistent between Sharding-JDBC and Sharding-Proxy.
- Renew modified data sources only, not renew all the data sources.
- Vibrate configurable for Snowflake key generator.
Bug Fixes
- Improve the compatibility of JDBC Driver URL.
- Delete statement with alias available.
- Check and disable updating sharding column.
- Fix wrong type of TINYINT and SMALLINT as INTEGER.