Skip to content

5.0.0
Compare
Choose a tag to compare
@menghaoranss menghaoranss released this 10 Nov 02:16
· 13652 commits to master since this release
5.0.0
d3409a2

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
Assets 2
Loading