apache/shardingsphere 5.5.1

on GitHub

API Changes

1. Authority: Mark privilege provider ALL_PERMITTED as deprecated and will be removed in future
2. DistSQL: Remove optional param usageCount from show storage units

New Features

1. Kernel: Add new doris, hive and presto sql parser module and database type

Enhancements

1. Pipeline: Add SHARDING_TOTAL_COUNT impl of JobExecutorServiceHandler to improve CPU core requirement
2. Pipeline: Support page query for inventory dumper and data consistency streaming query
3. Pipeline: Use case-insensitive identifiers to enhance the table metadata loader
4. Pipeline: Support primary key columns ordering for standard pipeline table metadata loader
5. DistSQL: Check privilege when registering or altering storage unit
6. DistSQL: Check duplicate actual data nodes when creating or altering sharding table rule
7. DistSQL: Add like support for show storage units
8. DistSQL: Rollback if import database configuration failed
9. Proxy: Make the results of show tables in order
10. Metadata: Collect table type for PostgreSQL
11. DistSQL: add table type to result set of show logical tables
12. Proxy: Trigger metadata collection when creating and deleting database and table
13. Proxy: Optimize Agent to support collecting metrics data from multiple data sources when used with Driver
14. Encrypt: Add unsupported check for combine statement with encrypt columns
15. SQL Parser: Support PostgreSQL COLLATION and CONSTRAINT keywords
16. SQL Parser: Support Mysql change replication with no server ids
17. SQL Parser: Support Mysql row and column aliases with ON DUPLICATE KEY UPDATE
18. SQL Parser: Support Mysql CALL sql with mysql prefix
19. SQL Parser: Support Mysql create loadable function returns int/dec
20. SQL Parser: Support parsing MySQL CREATE TABLESPACE/TABLE in Mysql-8
21. SQL Parser: Support parsing MySQL CREATE INDEX with ENGINE_ATTRIBUTE
22. SQL Parser: Support parsing MySQL LOAD DATA with @ variable
23. SQL Parser: Support parsing MySQL START REPLICA statement
24. SQL Parser: Support parsing MySQL json table function
25. Sharding: Revise all local index for sharding table and add object uniqueness level spi to control index token generator
26. SQL Parser: Enhance mysql json function visit statement result
27. SQL Federation: Support sql federation bit_count function for mysql
28. SQL Federation: Improve atan and anan2 sql function for mysql
29. Kernel: Support sql hint extract when sql contains dbeaver hint comment
30. Encrypt: Support select distinct(column) encrypt rewrite and refactor SubstitutableColumnNameToken build logic
31. SQL Federation: Support federated query mysql bin function
32. Kernel: Add extract combine left select in extractFromSelectStatementWithoutProjection method
33. Proxy Native: Add more graalvm reachability metadata for caffeine cache
34. SQL Parser: Enhance Oracle update statement as alias parse and add test case
35. SQL Federation: Support for federated query NOT operator
36. Encrypt: Support like concat nested concat statement rewrite with encrypt feature
37. Support PostgreSQL, openGauss function table and update from parse
38. Add assisted node to create and delete databases
39. Support cte with postgres and openGauss
40. Optimize the timezone support of PostgreSQLDateValueParser.
41. Sharding: Add NullsOrderType.LOW and NullsOrderType.HIGH to handle NULL order by in sharding feature
42. Support oracle column length unit type SQL parsing
43. Support postgresql limit and offset as null
44. Add mysql column not null sql parsing
45. Add mysql charset sql parsing
46. Use same transaction type in one transaction in jdbc adapter
47. Support for switching transaction types
48. Add inline sharding algorithms match actual data nodes check

Bug Fixes

1. Pipeline: InventoryTaskSplitter compatible with BigInteger primary key
2. Proxy: Support binary type bool value in PostgreSQL
3. Proxy: Support array type prepared param in PostgreSQL
4. Proxy: Support binary protocol value for text array in PostgreSQL
5. Metadata: Keep in-used storage node when unregister storage unit
6. Migration: Fix default data source lost when create migration job
7. Proxy: Fix duplicate results when querying information_schema.SCHEMATA
8. Proxy: Fix incorrect results for querying information_schema.SCHEMATA
9. Proxy: Fix NPE when execute show table status
10. Proxy: Fix no database selected exception occurs when show tables from db
11. DistSQL: Fix load single table error after creating logical data source
12. DistSQL: Fix set default single table storage unit to random failed
13. DistSQL: Fix set default single table storage unit to logical data source failed
14. DistSQL: Fix NPE when import metadata
15. Proxy: Fix the error that the process does not exit after proxy startup fail
16. Proxy: Fix the error that the persisted system metadata was not cleared after the database was deleted in the PostgreSQL scenario
17. SQL Federation: Fix federated query LocalDateTime conversion
18. SQL Federation: Fix push down sql execute error when sql contains chinese character with sql federation
19. Encrypt: Fix show create table wrong result with encrypt when data type contains float
20. SQL Parser: Support PostgreSQL do nothing conflict action
21. Kernel: Replace ThreadLocal with TransmittableThreadLocal in HintManager to support cross Thread usage
22. SQL Federation: Fix federation query binary type data query
23. Kernel: Use ConnectionPropertiesParser spi to parse jdbcUrl to solve oracle url parse error
24. Sharding: Fix Sharding column not tracked through aliases
25. SQL Binder: Add TableAvailable interface for CloseStatementContext, MoveStatementContext, FetchStatementContext and fix sql rewrite test case
26. Kernel: Fix column count assert exception caused by postgresql system table judge
27. SQL Federation: Fix null result in federated query for a single projected column
28. SQL Parser: Fix oracle nvl function and interval hour parse error
29. Sharding: Fix alter view exception when config sharding rule and binding table rule
30. SQL Federation: Fix sql federation unknown type exception caused by calcite wrong result type with bigint
31. Fixed the problem of missing storage unit when registering storage unit
32. Fix the issue where updating a non-encrypted table and using a subquery on an encrypted table.
33. Resolve the issue where "zip file closed" in versions prior to SpringBoot 2.3.
34. Fix the NPE when it does not contain a specified logic database in Driver.
35. Fix is need accumulate logic
36. Fix setSavepoint method invocation not cleaning up
37. Add insert select rewrite for encrypt
38. Fix the generated key column name case insensitivity error
39. Fix no database selected exception in the query sql
40. Fix savepoint manager not cleaned up in distributed transactions
41. Fix postgresql rollback only
42. Fix transaction context not cleaned up when xa transaction is committed
43. Fix the issue that cursor is not rewritten