[DISCUSS] Release Plan of ShardingSphere 5.3.0

[TeslaCN]

Release 5.3.0

Hi community,

After the release of 5.2.1 version, we have received a lot of feedback
from users and developers. Now we plan to release the ShardingSphere 5.3.0
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.

Mail: https://lists.apache.org/thread/xxv0slc4nlvbmyqomcvqw2p98j2x3hbf

Release Notes

API Changes

1. DistSQL: Refactor syntax API, please refer to the user manual
2. Proxy: Change the configuration style of global rule, remove the exclamation mark
3. Proxy: Allow zero-configuration startup, enable the default account root/root when there is no Authority configuration
4. Proxy: Remove the default logback.xml and use API initialization
5. JDBC: Remove the Spring configuration and use Driver + YAML configuration instead

Enhancements

1. DistSQL: New syntax REFRESH DATABASE METADATA, refresh logic database metadata
2. Kernel: Support DistSQL REFRESH DATABASE METADATA to load configuration from the governance center and rebuild MetaDataContext
3. Support PostgreSQL/openGauss setting transaction isolation level
4. Scaling: Increase inventory task progress update frequence
5. Scaling: DATA_MATCH consistency check support breakpoint resume
6. Scaling: Support drop consistency check job via DistSQL
7. Scaling: Rename column from sharding_total_count to job_item_count in job list DistSQL response
8. Scaling: Add sharding column in incremental task SQL to avoid broadcast routing
9. Scaling: Sharding column could be updated when generating SQL
10. Scaling: Improve column value reader for DATA_MATCH consistency check
11. DistSQL: Encrypt DistSQL syntax optimization, support like query algorithm
12. DistSQL: Add properties value check when REGISTER STORAGE UNIT
13. DistSQL: Remove useless algorithms at the same time when DROP RULE
14. DistSQL: EXPORT DATABASE CONFIGURATION supports broadcast tables
15. DistSQL: REGISTER STORAGE UNIT supports heterogeneous data sources
16. Encrypt: Support Encrypt LIKE feature
17. Automatically start distributed transactions when executing DML statements across multiple shards
18. Kernel: Support client \d for PostgreSQL and openGauss
19. Kernel: Support select group by, order by statement when column contains null values
20. Kernel: Support parse RETURNING clause of PostgreSQL/openGauss Insert
21. Kernel: SQL HINT performance improvement
22. Kernel: Support mysql case when then statement parse
23. Kernel: Supporting data source level heterogeneous database gateway
24. (Experimental) Sharding: Add sharding cache plugin
25. Proxy: Support more PostgreSQL datetime formats
26. Proxy: Support MySQL COM_RESET_CONNECTION
27. Scaling: Improve MySQLBinlogEventType.valueOf to support unknown event type
28. Kernel: Support case when for federation

Bug Fix

1. Scaling: Fix barrier node created at job deletion
2. Scaling: Fix part of columns value might be ignored in DATA_MATCH consistency check
3. Scaling: Fix jdbc url parameters are not updated in consistency check
4. Scaling: Fix tables sharding algorithm type INLINE is case-sensitive
5. Scaling: Fix incremental task on MySQL require mysql system database permission
6. Proxy: Fix the NPE when executing select SQL without storage node
7. Proxy: Support DATABASE_PERMITTED permission verification in unicast scenarios
8. Kernel: Fix the wrong value of worker-id in show compute nodes
9. Kernel: Fix route error when the number of readable data sources and weight configurations of the Weight algorithm are not equal
10. Kernel: Fix multiple groups of readwrite-splitting refer to the same load balancer name, and the load balancer fails problem
11. Kernel: Fix can not disable and enable compute node problem
12. JDBC: Fix data source is closed in ShardingSphereDriver cluster mode when startup problem
13. Kernel: Fix wrong rewrite result when part of logical table name of the binding table is consistent with the actual table name, and some are inconsistent
14. Kernel: Fix startup exception when use SpringBoot without configuring rules
15. Encrypt: Fix null pointer exception when Encrypt value is null
16. Kernel: Fix oracle parsing does not support varchar2 specified type
17. Kernel: Fix serial flag judgment error within the transaction
18. Kernel: Fix cursor fetch error caused by wasNull change
19. Kernel: Fix alter transaction rule error when refresh metadata
20. Encrypt: Fix EncryptRule cast to TransparentRule exception that occurs when the call procedure statement is executed in the Encrypt scenario
21. Encrypt: Fix exception which caused by ExpressionProjection in shorthand projection
22. Proxy: Fix PostgreSQL Proxy int2 negative value decoding incorrect
23. Proxy: PostgreSQL/openGauss support describe insert returning clause
24. Proxy: Fix gsql 3.0 may be stuck when connecting Proxy
25. Proxy: Fix parameters are missed when checking SQL in Proxy backend
26. Proxy: Enable MySQL Proxy to encode large packets
27. Kernel: Fix oracle parse comment without whitespace error
28. DistSQL: Fix show create table for encrypt table

Refactor

1. Scaling: Reverse table name and column name when generating SQL if it's SQL keyword
2. Scaling: Improve incremental task failure handling
3. Kernel: Governance center node adjustment, unified hump to underscore

[RaigorJiang]

Hi @TeslaCN
Sorry, I found a little problem:
Regarding the new feature, although the Agent's architecture already supports integration with ShardingSphere-JDBC, the plugins have not yet been fully adapted.
I suggest putting it in the next milestone, and let us release this feature after the plugins are completed.

[TeslaCN]

Got it.

[TeslaCN]

ShardingSphere 5.3.0 has been released. Have fun!