[DISCUSS] Release Plan of ShardingSphere 5.5.3

[RaigorJiang]

Release 5.5.3

Hi community,

After last release, we have received a lot of feedback from users and developers. Now we plan to release the ShardingSphere 5.5.3 version these days, which has made a lot of optimization and improvement for these feedback.

Please refer to this release notes to confirm whether it contains the features you expect. If I missed anything, please remind me ASAP. If there are any suggestions, please feel free to tell us.

Release Notes

CVE

1. Fix CVE-2025-55163, CVE-2025-58056, CVE-2025-58057 #36758
2. Fix CVE-2025-48924 #36085
3. Fix CVE-2024-7254 #36153

Metadata Storage Changes

1. Remove default_strategies prefix on sharding rule metadata persist - #34664

API Changes

1. Remove SQL formatting feature - #35390
2. Remove logging rule feature - #35458
3. Remove configuration property key system-log-level - #35493
4. Change ShardingSphere SQL log topic from ShardingSphere-SQL to org.apache.shardingsphere.sql - #37022
5. Add temporary config key instance-connection-enabled - #37694

New Features

1. Add ShardingSphere BOM - #36866
2. Decouple feature modules as pluggable - #36086
3. Decouple database types as pluggable - #35346
4. Decouple registry center types as pluggable - #36087
5. Proxy: Support Firebird Proxy - #35937
6. JDBC: Support ZooKeeper and ETCD URL format - #37037

Enhancements

1. Build: Support compiling and using ShardingSphere under OpenJDK 24 and 25 - #36688
2. Metadata: Support IPv6 for JDBC connection URL - #35289
3. Metadata: Support to load partition tables for PostgreSQL - #34346
4. Metadata: Support for connecting to Presto's Memory Connector - #34432
5. Kernel: Add LocalDate data type support - #37053
6. SQL Parser: Support to parse stored procedure syntax for MySQL - #36690
7. SQL Parser: Support to parse more SQL statements for MySQL - #36689
8. SQL Parser: Support to parse more SQL statements for SQLServer - #36695
9. SQL Parser: Support to parse more SQL statements for Oracle - #36696
10. SQL Parser: Support to parse more SQL statements for Hive - #36694 #37074
11. SQL Parser: Support to parse CREATE MATERIALIZED VIEW for Doris - #31499
12. SQL Parser: Support to parse CREATE FUNCTION with $$ symbol for PostgreSQL and openGauss - #35947
13. SQL Binder: Support to bind more SQL statements - #36697
14. SQL Binder: Add ALTER TABLE metadata check - #35877
15. SQL Router: Add SELECT with UNION ALL routing to multi data sources check - #35037
16. SQL Router: Improve support for executing tableless SQL with single data source - #35659
17. SQL Router: Add max-union-size-per-datasource property to batch UNION ALL rewrite per data source and keep parallel execution - #37405
18. DistSQL: Add job sharding nodes info to the query results of SHOW MIGRATION LIST - #35053
19. DistSQL: Add DistSQL for query storage units which used in single rule - #35131
20. Proxy: Implement write bool binary data type for PostgreSQL protocol - #35831
21. Proxy: Add authority check on SQL SHOW CREATE DATABASE for MySQL - #36862
22. Sharding: Using cache to avoid memory overflow from inline expression parsing - #22196
23. Sharding: Add digital suffix check with binding table names - #35293
24. Encrypt: Use EncryptDerivedColumnSuffix to enhance encrypt table subquery rewrite logic - #34829
25. Encrypt: Add quotes to encrypt rewrite derived columns - #34950
26. Encrypt: Support NOT LIKE operator in encryption feature - #35984
27. Readwrite-splitting: Update transactional read query strategy default type as PRIMARY - #36477
28. Pipeline: Improve pipeline job progress incremental latestActiveTimeMillis persistence - #34655
29. Pipeline: Improve heterogeneous databases migration - #35424
30. Pipeline: Improve DATA_MATCH data consistency check to use range streaming query - #35740
31. Pipeline: Add streaming-range-type property and LARGE impl in DATA_MATCH consistency check on MySQL sharding table for better performance - #35786
32. Pipeline: Improve migration consistency check to reflect storage unit maxPoolSize dynamically - #36507
33. Pipeline: Improve "show migration check status" inventory_finished_percentage column inaccurate result - #36509
34. Pipeline: Compatible with COMPLEX_INLINE allow-range-query-with-inline-sharding - #36524
35. Pipeline: Support pipeline job realtime reflection on proxy global properties after restarting - #36749
36. Pipeline: InventoryDumper reuse table inventory calculator for better function and performance - #36830
37. Pipeline: Improve "alter transmission rule": verify STREAM_CHANNEL TYPE NAME - #36864
38. Pipeline: Support multi-columns unique key first integer column splitting - #36935
39. Pipeline: Support unique key first integer column exact splitting - #37517
40. Pipeline: Support unique key first integer column possible null value - #37522
41. Pipeline: Support unique key first integer column exact or estimated splitting based on data sparseness - #37542
42. Pipeline: Support unique key first big integer column splitting - #37574
43. Pipeline: Support unique key first string column exact splitting - #37543
44. Pipeline: Support multi-columns unique key non-first column nullable - #37647
45. Encrypt: Support handling show create view result decoration in encrypt - #37299
46. JDBC: Enhance ResultSetUtils to support flexible string date/time conversions - 37424
47. SQL Binder: Support Grant statement SQL bind - #36207

Bug Fixes

1. Kernel: Fix not return generate key when set null in INSERT statement - 35783
2. Kernel: Add AllowNotUseDatabaseSQLStatementAttribute to support some mysql dal statement execute without use database - #37033
3. Metadata: Fix the exception to rename schema name when executing ALTER SCHEMA - #34465
4. SQL Parser: Support multiple column names with pivot and unpivot clause - 35586
5. SQL Parser: Fix set OnDuplicateKeyColumnsSegment on INSERT for PostgreSQL - #34425
6. SQL Parser: Fix SQL parser error when SQL contains implicit concat expression for MySQL - #34660
7. SQL Parser: Fix SQL parser error when SQL contains subquery with alias for Oracle - #35239
8. SQL Parser: Fix multiple SQLs split error when comma contained - #31609
9. SQL Binder: Fix unable to find the outer table in the NotExpressionBinder - 36135
10. SQL Binder: Fix unable to find the outer table in the ExistsSubqueryExpressionBinder - #36068
11. SQL Binder: Fix column bind exception caused by oracle XMLELEMENT function first parameter without quote - #36963
12. Transaction: Fix conflicting dependencies of BASE transaction integration module - #35142
13. Transaction: Alleviate connection leaks caused by SEATA client throwing exceptions - #34463
14. SQL Federation: Fix Operation not allowed after ResultSet closed exception when use SQL federation - #35206
15. DistSQL: Fix duplicate result when show rules used storage unit with readwrite-splitting rule - #35129
16. DistSQL: Fix missing comma in ALTER SQL_FEDERATION RULE - #35523
17. JDBC: Fix some wrong JDBC database metadata retrieve logics - #34959
18. JDBC: Fix getting database name from SQL statement context - #34960
19. JDBC: Support set data source properties type with java.time.Duration - #35241
20. JDBC: Resolve statement manager leaks when creating multiple statements - #35665
21. JDBC: Fix the issue where cached connections in DriverDatabaseConnectionManager were not released in time - 35834
22. JDBC: Clear batch generated keys result set when call clearBatch method - 37204
23. JDBC: Fix Oracle TIMESTAMP WITH TIME ZONE ORDER BY exception - #37181
24. Proxy: Fix SHOW PROCESSLIST not wait for all nodes - #35348
25. Proxy: Fix NoSuchElementException exception when execute MySQL SHOW VARIABLES without current database - #35550
26. Proxy: Fix column length for PostgreSQL string binary protocol value - 35840
27. Proxy: Fix the connection leak caused by rollback failure in Proxy - 35867
28. Proxy: Fix the behavior difference of select built-in function names with spaces -#36537
29. Proxy: Fix MySQL text protocol datetime fractional seconds output - #37410
30. Proxy: Fix IndexOutOfBoundsException for MySQL no-FROM multi-projection SELECT routed to admin path - #37391
31. Proxy: Fix MySQL binary protocol datetime/time fractional seconds precision - #37294
32. Proxy: Fix PostgreSQL boolean text output to return t/f as per protocol - #37184
33. Mode: Fix issue of drop schema can not work on standalone mode - #34470
34. Encrypt: Resolve rewrite issue in nested concat function - #35815
35. Sharding: Fix mod sharding algorithm judgement -#36386
36. Sharding: Fix check inline sharding algorithms in table rules - #36999
37. Sharding: Fix wrong sharding condition merge when sharding column in case-sensitive - #37389
38. Sharding: Fix wrong merge sharding condition logic caused by different type sharding value - #37528
39. Pipeline: Recover value of migration incremental importer batch size - #34670
40. Pipeline: Fix InventoryDumper first time dump SQL without ORDER BY on multiple columns unique key table - #34736
41. Pipeline: Fix MySQL JDBC query properties extension when SSL is required on server - #36581
42. Pipeline: Fix migration might skip some records on big table after job restarting - #36878
43. Pipeline: Fix unsigned number column value type inconsistent in inventory and incremental - #37280
44. Pipeline: Fix PostgreSQL migration create table SQL generation failure caused by locale-formatted sequence values - #28360
45. Pipeline: MySQLBinlogClient compatible with async exception - #37631
46. DistSQL: Fix load single table with specific schema - #37535
47. Transaction: Fix XA data source enlist failure caused connection leaks - 37593

Change Logs

1. MILESTONE

[logan2013]

awesome

[bactoria]

Great news! I’ve been waiting for these fixes.
Hope to see the official release as soon as possible!

[pan1998]

I hope it can support XinChuang(信创) database, such as the widely used Dameng 8 database.

[terrymanu]

I hope it can support XinChuang(信创) database, such as the widely used Dameng 8 database.

Please leave the last pure land for open source.

[RaigorJiang]

Due to the need to fix some nightly E2E issues, this release will be delayed.

Release Notes will be updated then.

Looking forward to the release. Thank you.