[DISCUSS] Release Plan of ShardingSphere 5.1.2

[TeslaCN]

Release 5.1.2

Hi community,

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

Release Notes

New Feature

1. Kernel: Alpha version to support SQL dialect translate for MySQL and PostgreSQL
2. Kernel: Support custom schema for PostgreSQL and openGauss
3. Kernel: Support create/alter/drop view statement for PostgreSQL and openGauss
4. Kernel: Support openGauss cursor statement
5. Kernel: Support use customize system database
6. Kernel: Support get openGauss and MySQL create SQL
7. Kernel: Support get postgres create SQL
8. Proxy: Official support for quickly deploying a ShardingSphere-Proxy cluster with a ZooKeeper cluster in Kubernetes using Helm
9. JDBC: Support ShardingSphere JDBC Driver
10. Scaling: Support PostgreSQL auto create table
11. Scaling: Support scaling for table with customized schema in PostgreSQL and openGauss
12. Scaling: Support scaling for table with text primary key and without integer primary key
13. Mode: Registry center supports PG/openGauss three-level structure
14. Mode: Registry center supports database-level distributed lock

Enhancement

1. Kernel: Support copy statement for PostgreSQL and openGauss
2. Kernel: Support alter/drop index statement for PostgreSQL
3. Kernel: Support update force index statement for MySQL
4. Kernel: Support create/alter/drop schema for openGauss
5. Kernel: Optimize RoundRobinReplicaLoadBalanceAlgorithm and RoundRobinTrafficLoadBalanceAlgorithm logic
6. Kernel: Optimize metadata loading logic when frontendDatabaseType and backendDatabaseType are different
7. Kernel: Refactor meta data load logic
8. Kernel: Optimize show processlist statement
9. Kernel: Improve performance about large tables loaded
10. Kernel: Support execute comment statement
11. Kernel: Support view in sharding rule
12. Kernel: Support parsing CREATE ROLLBACK SEGMENT in Oracle
13. Kernel: Support Parsing DROP TYPE in openGauss
14. Kernel: Support Parsing ALTER TYPE in openGauss
15. Kernel: Support parsing DROP DISKGROUP in Oracle
16. Kernel: Support parsing CREATE DISKGROUP in Oracle
17. Kernel: Support parsing DROP FLASHBACK ARCHIVE in Oracle
18. Kernel: Support Parsing CHECKPOINT in openGauss
19. Kernel: Support parsing CREATE FLASHBACK ARCHIVE in Oracle
20. Kernel: Add PostgreSQL Close Statement
21. Kernel: Support Parsing DROP CAST in openGauss
22. Kernel: Support parsing CREATE CAST in openGauss
23. Kernel: Support parsing CREATE CONTROL FILE in Oracle
24. Kernel: Support Parsing DROP DIRECTORY in openGauss
25. Kernel: Support parsing ALTER DIRECTORY in openGauss
26. Kernel: Support parsing CREATE DIRECTORY in openGauss
27. Kernel: Add PostgreSQL Checkpoint Statement
28. Kernel: Support parsing DROP SYNONYM in openGauss
29. Kernel: Support parsing CREATE SYNONYM in openGauss
30. Kernel: Support parsing ALTER SYNONYM in openGauss
31. Kernel: Add PostgreSQL CALL Statement
32. Kernel: Support parsing CREATE PFILE in Oracle
33. Kernel: Support parsing CREATE SPFILE in Oracle
34. Kernel: Support parsing ALTER SEQUENCE in Oracle
35. Kernel: Support parsing CREATE CONTEXT in Oracle
36. Kernel: Support Parsing ALTER PACKAGE in oracle
37. Kernel: Support parsing CREATE SEQUENCE in Oracle
38. Kernel: Support parsing ALTER ATTRIBUTE DIMENSION in Oracle
39. Kernel: Support parsing ALTER ANALYTIC VIEW in Oracle
40. Kernel: Use ShardingSphere SPI in SQLVisitorFacade
41. Kernel: Use ShardingSphere SPI in DatabaseTypedSQLParserFacade
42. Kernel: Support parsing ALTER OUTLINE in Oracle
43. Kernel: Support parsing DROP OUTLINE in Oracle
44. Kernel: Support parsing drop edition in oracle
45. Kernel: Support WITH Common Table Expression of SQLServer
46. Kernel: Exclude parenthesis from SubquerySegment's start and stop index in withClause
47. Kernel: Refactor JoinTableSegment
48. Kernel: Support parsing DROP SYNONYM in Oracle
49. Kernel: Support parsing CREATE DIRECTORY in Oracle
50. Kernel: Support parsing CREATE SYNONYM in Oracle
51. Kernel: Support for XmlNamespaces Clause of SQLServer SELECT Statement
52. Kernel: Support parsing Alter Database Dictionary in Oracle
53. Kernel: Support FOR Clause of SQLServer SELECT Statement
54. Kernel: Support Parsing ALTER DATABASE LINK in Oracle
55. Kernel: Support CREATE EDITION Parsing in Oracle
56. Kernel: Support parsing ALTER TRIGGER in Oracle
57. Kernel: Add SQLServer REVERT Statement
58. Kernel: Support Parsing DROP TEXT SEARCH in PostgreSQL
59. Kernel: Add drop server for PostgreSQL
60. Kernel: Support Parsing ALTER VIEW in Oracle
61. Kernel: Add drop access method for PostgreSQL
62. Kernel: Support Parsing DROP ROUTINE in PostgreSQL
63. Kernel: Proofread SQLServer DROP USER Statement
64. Kernel: Support parsing DROP TRIGGER in Oracle
65. Kernel: Support parsing Drop subscription in PostgreSQL
66. Kernel: Add drop operator class for PostgreSQL
67. Kernel: Support parsing DROP PUBLICATION in PostgreSQL
68. Kernel: Support Parsing DROP VIEW in Oracle
69. Kernel: Support Parsing DROP TRIGGER in PostgreSQL
70. Kernel: Support Parsing DROP DIRECTORY in Oracle
71. Kernel: Support Parsing DROP STATISTICS for PostgreSQL
72. Kernel: Add drop type SQL parser for PostgreSQL
73. Kernel: Support Parsing DROP RULE in PostgreSQL
74. Kernel: Proofread SQLServer ALTER LOGIN Statement
75. Kernel: Support parsing PostgreSQL DROP FOREIGN DATA WRAPPER
76. Kernel: Small changes to PostgreSQL DROP EVENT TRIGGER statement
77. Proxy: ShardingSphere-Proxy MySQL supports receiving MySQL packet more than 16 MB
78. Proxy: Supports netty parameter ChannelOption.SO_BACKLOG configurable in ShardingSphere-Proxy
79. Proxy: Optimize so-reuseaddr in netty to solve the problem of port occupied
80. Proxy: Docker image of ShardingSphere-Proxy supports aarch64 platform
81. Proxy: Make server version configurable in ShardingSphere-Proxy MySQL
82. Proxy: Supports more character sets in ShardingSphere-Proxy PostgreSQL/openGauss
83. Proxy: Make default port configurable in ShardingSphere-Proxy
84. Scaling: Compatible with HA ports for openGauss:3.0 when thread_pool enabled
85. Scaling: Optimize ZooKeeper event handling in PipelineJobExecutor to avoid blocking ZooKeeper events
86. Scaling: Make table name case-insensitive in whole process
87. Scaling: Improve replication slot cleanup for PostgreSQL and openGauss
88. Scaling: Improve lock protection for job preparation
89. Scaling: Support PostgreSQL insert on conflict do update
90. Scaling: Do not cache data source in GlobalDataSourceRegistry to avoid possible shared resource close issue
91. Scaling: Reuse data source pool as more as possible to reduce working database connections
92. DistSQL: REFRESH TABLE METADATA supports specifying PostgreSQL's schema
93. DistSQL: ALTER SHARDING TABLE RULE add validation of binding table
94. Mode: ShardingSphere-JDBC supports configuring database connection name
95. Distributed Transaction: DistSQL is prohibited from executing within a transaction
96. Distributed Transaction: autocommit = 0, DDL part of DML will automatically open the transaction

Bug Fix

1. Kernel: Fix parsing error about show statement for PostgreSQL and openGauss
2. Kernel: Fix parsing error about time extract function for for PostgreSQL and openGauss
3. Kernel: Fix parsing error about select mod function for for PostgreSQL and openGauss
4. Kernel: Fix PSQLException when execute join statement with multi schema in readwrite scenario
5. Kernel: Fix wrong route result when execute create schema statement in encrypt scenario
6. Kernel: Fix npe when execute drop schema if exist statement
7. Kernel: Fix wrong route result when execute SELECT LAST_INSERT_ID() AS id; statement
8. Kernel: Fix npe when execute use database when database doesn't contains datasource
9. Kernel: Fix create function with set var
10. Proxy: Fix NPE caused by column's case unmatched in PostgreSQLComDescribeExecutor
11. Proxy: Complete command tags for schema DDL in ShardingSphere-Proxy PostgreSQL / openGauss
12. Scaling: Fix MySQL unsigned type null value cause error during increment task
13. Scaling: Fix resource leak caused by error occurred when creating DataSource in ShardingSphere-Scaling
14. Scaling: Fix ShardingSphereDataSource creation ignoring other rules
15. Scaling: Fix on preparation job could not be stopped
16. Scaling: Fix data source property url and jdbcUrl compatibility
17. Scaling: Fix openGauss logical replication slot creation, avoid possible incremental data loss
18. Scaling: Update local job status before persisting job status to registry center, make sure it won't be overwritten later
19. Scaling: Handling null value in TestDecodingPlugin for PostgreSQL
20. DistSQL: Fix SET VARIABLE modification not taking effect in stand-alone and memory mode
21. DistSQL: Fix the inconsistency between SHOW INSTANCE LIST display data and actual data
22. DistSQL: Fix capitalization sensitivity in sharding DistSQL
23. Mode: Fix the new version metadata lost data after the Scaling changes the table sharding rules
24. Distributed Transaction: Fix getIndexInfo with catalog

API Changes

1. DistSQL: Change EXPORT SCHEMA CONFIG to EXPORT DATABASE CONFIG
2. DistSQL: Change IMPORT SCHEMA CONFIG to IMPORT DATABASE CONFIG
3. DistSQL: Change SHOW SCHEMA RESOURCES to SHOW DATABASE RESOURCES
4. DistSQL: Change COUNT SCHEMA RULES to COUNT DATABASE RULES
5. Mode: Adjust db-discovery algorithm configuration
6. Authority: Authority provider ALL_PRIVILEGES_PERMITTED updated to ALL_PERMITTED
7. Authority: Authority provider SCHEMA_PRIVILEGES_PERMITTED updated to DATABASE_PERMITTED

Refactor

1. Scaling: Refactor JobConfiguration, prepare for different types of jobs reuse and extension
2. Mode: Optimize compute node structure of the registry center
3. Mode: Use uuid instead of ip@port as instance id

[tristaZero]

Look nice to me and look forward!