apache/shardingsphere 5.0.0-beta

on GitHub

New feature

1. New DistSQL to load and show all the ShardingSphere configuration rules
2. Support join SQL from different database instances
3. Support multiple backend database types for new feature of database gateway
4. Support creating and updating the authentication online
5. Add a new automated agent module

API Change

1. QueryReplica configuration item is replaced by read-write-splitting
2. Authentication configuration item of ShardingProxy is replaced by AUTHORITY
3. Optimize the dataSource configuration for ShardingJDBC with dataSourceClassName
4. New API for automated sharding table configuration to provide standard and automated sharding tables
5. Remove configuration item acceptor-size from ShardingProxy
6. Create a built-in sharding algorithm SPI which allows users to directly configure the class name as in 4.x

Enhancement

1. Improve metadata loading process distinctly
2. Greatly enhance the SQL parsing for Oracle, SQLServer and PostgreSQL
3. Support loading privileges from MySQL/PostgreSQL/SQLServer/Oracle
4. Support DDL statement for encryption feature
5. Support rewrite owner table name of projection if using sharding and encrypt together
6. When using SELECT * from encrypted SQL, add quote char for the rewritten column to avoid conflict with keyword
7. Support PostgreSQL JSON/JSONB/pattern matching operator parse
8. Support MySQL/PostgreSQL CREATE/ALTER/DROP TABLESPACE statement
9. Support PostgreSQL PREPARE, EXECUTE, DEALLOCATE statement
10. Support PostgreSQL EXPLAIN statement
11. Support PostgreSQL START/END TRANSACTION statement
12. Support PostgreSQL ALTER/DROP INDEX statement
13. Support CREATE TABLESPACE of PostgreSQL
14. Support MySQL CREATE LOADABLE FUNCTION statement
15. Support MySQL/PostgreSQL ALTER TABLE RENAME statement
16. Support PostgreSQL Close command

Refactor

1. New schema structure in registry center
2. Remove Nacos and Apollo config center support
3. ShardingScaling leverages elasticJob as its job distribution
4. Refactor the metadata content and its update process

Bug Fix

1. Bugfix for cannot use SELECT * wildcard when readwrite-splitting only
2. Fix instance error when the custom sharding algorithm does not match the configuration type.
3. Fix NoSuchTableException when executing drop table if exists statement
4. Fix the wrong table rewrite in UPDATE ... SET ... statement
5. Fix wrong table rewrite in CREATE/ALTER TABLE statement foreign key reference table
6. Fix projection owner check exception when existing subquery temporary table
7. Fix Oracle/SQL92 SELECT ... WHERE ... LIKE statement class cast exception
8. Fix MySQL SELECT EXISTS ... FROM ... statement parse error
9. Fix the wrong result of SHOW INDEX statement
10. Fix SELECT ... GROUP BY ... statement rewrite and merge result error
11. Fix CREATE TABLE statement rewrite error for encrypt
12. Fix exception occurs in PostgreSQL Proxy when reading text format parameter values
13. Enhance the support of array object for PostgreSQL Proxy
14. Fix the bug of Datatype casting for ShardingProxy
15. PostgreSQL Proxy supports using numeric type
16. Fix PostgreSQL Proxy transaction command complete packet's tag incorrect
17. Fix PostgreSQL Proxy may return packet which is not expected by the client

Change Log

1. MILESTONE