apache/shardingsphere 5.0.0

on GitHub

New feature

1. Support parsing SQL comment
2. New DistSQL syntax: shadow rule management
3. New DistSQL syntax: scaling job management
4. New DistSQL syntax: disable proxy instance
5. New DistSQL syntax: disable readwrite-splitting read data source
6. New DistSQL syntax: DROP SHARDING ALGORITHM
7. New DistSQL syntax: ALTER RESOURCE
8. New DistSQL syntax: CREATE SHARDING ALGORITHM
9. New DistSQL syntax: CREATE DEFAULT SHARDING [TABLE | DATABASE] STRATEGY
10. New DistSQL syntax: SHOW ALL VARIABLE
11. New DistSQL syntax：SHOW VARIABLE variableName;
12. Support 3 modes, including Memory, Standalone and Cluster mode
13. Proxy supports for openGauss
14. Scaling: Add basic support for openGauss
15. Scaling: Add incremental task completion detect algorithm SPI interface
16. Scaling: Add data consistency check algorithm SPI interface
17. Scaling: Basic support of create table on target automatically for MySQL and openGauss
18. Scaling: Support auto switch cluster configuration when job finished
19. Scaling: Add more DistSQL support such as data consistency check, etc

API Change

1. Add schema name configuration for ShardingSphere-JDBC
2. Add default sharding column configuration
3. Change the default authority provider from NATIVE to ALL_PRIVILEGES_PERMITTED
4. SCTL syntax adjustment, merged with DistSQL RAL syntax
5. SHOW RESOURCES DistSQL is adjusted to SHOW SCHEMA RESOURCES
6. Remove shadow logical field, support shadow algorithm

Enhancement

1. Support parsing MySQL union/union all statement
2. Support PostgreSQL ABORT statement
3. Refactor and improve metadata loading process
4. Support PostgreSQL CREATE INDEX statement to generate index automatically when no index is specified
5. Support SQL statement execution with logical schema
6. Support binding tables configuration with different sharding columns
7. Optimize kernel performance
8. Proxy supports queries to part of information_schema tables to optimize client connection experience
9. DistSQL supports using quotation marks to use keywords as parameter names
10. The password in the ADD RESOURCE statement supports special characters
11. ADD RESOURCE supports custom JDBC parameters and connection pool properties
12. DROP RESOURCE supports optional parameter ignore single tables, used to ignore single table rule restrictions
13. Support the use of DistSQL to create sharding table rule based on readwrite-splitting rules
14. SHOW DATABASES statement supports like syntax
15. CREATE SHARDING TABLE RULE supports the use of inline expressions to specify resources
16. CREATE SHARDING TABLE RULE supports configuration using dataNodes
17. CREATE SHARDING TABLE RULE supports reuse of existing algorithms
18. SET VARIABLE, support to modify proxy configuration
19. PostgreSQL's protocol enhancements (Such as supports Portal, unspecified type)
20. Using Netty executor to optimize Proxy performance in specified scenarios
21. Make memory strictly fetch size configurable in Proxy
22. Scaling: Improve support for PostgreSQL
23. Scaling: Support concurrent data consistency check of source and target side

Refactor

1. Refactor the SingleTable feature to support Encrypt multiple data sources
2. Adjust the persistent data structure of the registry center state node
3. Remove the SQL rewrite of DML for Shadow
4. Support the SQL routing of DDL for Shadow
5. Scaling: Refactor default implementation of incremental task completion detect algorithm
6. Scaling: Refactor default implementation of data consistency check algorithm
7. Scaling: Remove HTTP API and binary distribution

Bug Fix

1. Fix sharding interval algorithm
2. Fix SHOW INDEX FROM TABLE FROM TABLE statement rewrite exception
3. Fix Encrypt multi tables join query rewrite exception
4. Fix subquery index out of range exception
5. Fix wrong result of Oracle paging query
6. Fix the rewrite exception when KeyGenerateStrategy is not configured in the Sharding feature
7. Fix federation executor engine exception caused by Oracle dialect case
8. Fix Sharding and Encrypt integration usage rewrite exception
9. Fix Oracle metadata loading exception
10. Fix the issue that SHOW RESOURCES statement cannot display custom attributes
11. Fix the issue that SQL execution exception is not thrown
12. Fix Etcd can not send node added event
13. Fix PostgreSQL rows contains null value may be missing in query result
14. Fix PostgreSQL metadata columns are out-of-order
15. Fix client character set may be incorrect in Proxy

Change Log

1. MILESTONE