This is an automated email from the ASF dual-hosted git repository.
terrymanu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 5c08f8f7a41 Update release notes (#40339)
5c08f8f7a41 is described below
commit 5c08f8f7a416340ba9e504f044ababb4d0059ac8
Author: Liang Zhang <[email protected]>
AuthorDate: Thu Oct 22 19:43:47 2026 +0800
Update release notes (#40339)
* Run initial blind PR reviews in parallel
* Update release notes
---
RELEASE-NOTES.md | 46 ++++++++++++++++++----------------------------
1 file changed, 18 insertions(+), 28 deletions(-)
diff --git a/RELEASE-NOTES.md b/RELEASE-NOTES.md
index fef88cee685..79fd497663c 100644
--- a/RELEASE-NOTES.md
+++ b/RELEASE-NOTES.md
@@ -4,7 +4,7 @@
1. DistSQL: Add DistSQL to manage sharding key generate strategies -
[#38572](https://github.com/apache/shardingsphere/pull/38572)
1. DistSQL: Add DistSQL to manage sharding key generators -
[#38576](https://github.com/apache/shardingsphere/pull/38576)
-1. SHARDING: Adjustment sharding api to support column-level auto-increment
and global auto-increment for key generate strategy
-[#38528](https://github.com/apache/shardingsphere/pull/38528)
+1. SHARDING: Adjustment sharding api to support column-level auto-increment
and global auto-increment for key generate strategy
-[#38294](https://github.com/apache/shardingsphere/pull/38294)
### New Features
@@ -21,12 +21,12 @@
### Bug Fixes
1. Infra: Avoid retaining transient multi-object lookup keys in
`OrderedSPILoader` -
[#38980](https://github.com/apache/shardingsphere/pull/38980)
-1. Infra: Fix invalid target selection after counter overflow in
`RoundRobinLoadBalanceAlgorithm` -
[#39340](https://github.com/apache/shardingsphere/pull/39340)
+1. Infra: Fix invalid target selection after counter overflow in
`RoundRobinLoadBalanceAlgorithm` -
[#39339](https://github.com/apache/shardingsphere/pull/39339)
1. Infra: Reject incomplete WEIGHT load balancer properties during rule
configuration validation -
[#39378](https://github.com/apache/shardingsphere/pull/39378)
1. Infra: Fix stale weights in WEIGHT load balancer after same-size read data
source changes - [#39995](https://github.com/apache/shardingsphere/pull/39995)
1. Infra: Fix false table existence check failures for quoted schema names in
`SupportedSQLCheckEngine` -
[#40069](https://github.com/apache/shardingsphere/pull/40069)
-1. Infra: Wrap `IllegalStateException` from data source pool properties
content validation in `DataSourcePoolPropertiesValidator` -
[#40199](https://github.com/apache/shardingsphere/pull/40199)
-1. SQL Parser: Preserve unary NOT as NotExpression for scalar-subquery table
extraction in PostgreSQL -
[#38187](https://github.com/apache/shardingsphere/pull/38187)
+1. Infra: Fix error handling for invalid data source pool properties -
[#40199](https://github.com/apache/shardingsphere/pull/40199)
+1. SQL Parser: Preserve unary NOT for scalar-subquery table extraction in
PostgreSQL - [#38187](https://github.com/apache/shardingsphere/pull/38187)
1. SQL Parser: Fix wrong parameter index parse in MySQL, Doris -
[#38624](https://github.com/apache/shardingsphere/pull/38624)
1. SQL Parser: Fix reversed parameter marker order for openGauss `LIMIT
offset, row-count` -
[#39242](https://github.com/apache/shardingsphere/pull/39242)
1. SQL Parser: Preserve PostgreSQL `CREATE TABLE` column nullability metadata
- [#39412](https://github.com/apache/shardingsphere/pull/39412)
@@ -46,10 +46,10 @@
1. SQL Parser: Fix No value specified for parameter exception when sql is
'INSERT INTO tableName ON CONFLICT DO UPDATE set WHERE ' -
[#38668](https://github.com/apache/shardingsphere/pull/38668)
1. SQL Parser: Preserve parentheses around column projections in PostgreSQL,
openGauss, SQLServer, and Hive -
[#40010](https://github.com/apache/shardingsphere/pull/40010)
1. SQL Parser: Fix `ORDER BY` binding for Oracle set operations -
[#40019](https://github.com/apache/shardingsphere/pull/40019)
-1. SQL Binder: Add DialectFunctionOption to handle wrong skip column bind in
ColumnSegmentBinder -
[#38350](https://github.com/apache/shardingsphere/pull/38350)
+1. SQL Binder: Fix columns being incorrectly skipped during binding -
[#38350](https://github.com/apache/shardingsphere/pull/38350)
1. SQL Binder: Fix wrong bind info when order by refer column from with
temporary table - [#38353](https://github.com/apache/shardingsphere/pull/38353)
1. SQL Binder: Fix wrong column label case for PostgreSQL and openGauss
function projections -
[#39393](https://github.com/apache/shardingsphere/pull/39393)
-1. SQL Binder: Bind PostgreSQL SYSTEM_USER as a niladic function instead of a
column - [#39385](https://github.com/apache/shardingsphere/pull/39385)
+1. SQL Binder: Fix PostgreSQL SYSTEM_USER being incorrectly bound as a column
- [#39385](https://github.com/apache/shardingsphere/pull/39385)
1. SQL Binder: Preserve RETURNING clause when binding UPDATE and DELETE
statements - [#40070](https://github.com/apache/shardingsphere/pull/40070)
1. SQL Binder: Fix recursive CTE binding when anchor query uses shorthand
projection - [#40073](https://github.com/apache/shardingsphere/pull/40073)
1. Metadata: Fix MySQL metadata loading fallback when JDBC catalog is null for
named tables - [#38855](https://github.com/apache/shardingsphere/pull/38855)
@@ -92,13 +92,11 @@
1. Proxy: Add error handling for unknown or closed BLOB handles and ids in
Firebird - [#39773](https://github.com/apache/shardingsphere/pull/39773)
1. JDBC & Proxy: Remove default MySQL prepared statement query properties when
creating data sources -
[#38593](https://github.com/apache/shardingsphere/pull/38593)
1. Mode: Fix rule metadata not removed from memory after dropping rules in
Etcd cluster mode -
[#38561](https://github.com/apache/shardingsphere/pull/38561)
-1. Agent: Fix wrong target class name in StaticMethodAdviceExecutor error logs
- [#39077](https://github.com/apache/shardingsphere/pull/39077)
1. Pipeline: Fix MySQL JSON literal decoding in migration -
[#38622](https://github.com/apache/shardingsphere/pull/38622)
1. Pipeline: Fix MySQL zero-value temporal binlog decoding with fractional
precision in migration -
[#38629](https://github.com/apache/shardingsphere/pull/38629)
1. Pipeline: Fix escape MySQL JSON binlog control characters -
[#38800](https://github.com/apache/shardingsphere/pull/38800)
1. Pipeline: Use UTF-8 to decode MySQL JSON binlog string and key values
instead of the JVM default charset -
[#39140](https://github.com/apache/shardingsphere/pull/39140)
-1. Readwrite-splitting: Fix swapped data source type and name in duplicate
actual data source error message -
[#39372](https://github.com/apache/shardingsphere/pull/39372)
-1. Sharding: Support ORDER BY MySQL VARBINARY column by wrapping byte[] values
in a Comparable adapter -
[#38699](https://github.com/apache/shardingsphere/pull/38699)
+1. Sharding: Support ORDER BY MySQL VARBINARY column -
[#38699](https://github.com/apache/shardingsphere/pull/38699)
1. Sharding: Fix generated actual index names exceeding database identifier
length limits while preserving legacy generated index name compatibility -
[#38449](https://github.com/apache/shardingsphere/pull/38449)
1. Sharding: Fix AUTO_INTERVAL sharding failure under JVM default locales that
use comma decimal separators -
[#38806](https://github.com/apache/shardingsphere/pull/38806)
1. Sharding: Compute the Snowflake key generator epoch in UTC instead of the
JVM default timezone -
[#38932](https://github.com/apache/shardingsphere/pull/38932)
@@ -110,10 +108,9 @@
1. Sharding: Use configured sharding column name when checking UPDATE
assignments - [#39864](https://github.com/apache/shardingsphere/pull/39864)
1. Sharding: Fix INTERVAL sharding on one-sided range outside datetime bounds
- [#39862](https://github.com/apache/shardingsphere/pull/39862)
1. Sharding: Fix GROUP_CONCAT merge result when all values are NULL -
[#39860](https://github.com/apache/shardingsphere/pull/39860)
-1. Sharding: Fix swapped start and stop offset in sharding value offset error
message - [#39858](https://github.com/apache/shardingsphere/pull/39858)
1. Sharding: Fix sharding constraint reviser removing every actual table
suffix - [#39868](https://github.com/apache/shardingsphere/pull/39868)
1. Sharding: Fix DISABLE_AUDIT_NAMES hint ignoring auditor name case -
[#39871](https://github.com/apache/shardingsphere/pull/39871)
-1. Sharding: Include auto tables in ShardingRuleConfiguration logic table
names - [#39854](https://github.com/apache/shardingsphere/pull/39854)
+1. Sharding: Include auto tables in configured logical table names -
[#39854](https://github.com/apache/shardingsphere/pull/39854)
1. Sharding: Fix NULL ordering when merging ORDER BY results for ClickHouse
and Presto - [#40014](https://github.com/apache/shardingsphere/issues/40014)
1. Sharding: Rewrite generated ORDER BY column owners to actual table names -
[#39866](https://github.com/apache/shardingsphere/pull/39866)
1. Sharding: Reject sharding auto table configured with none sharding strategy
- [#39869](https://github.com/apache/shardingsphere/pull/39869)
@@ -130,7 +127,7 @@
### Enhancements
-1. SQL Parser: Support additional MySQL CREATE TABLE, CREATE FUNCTION, CREATE
TRIGGER, INSTALL COMPONENT, LOAD XML, GET DIAGNOSTICS and SELECT syntax
+1. SQL Parser: Support additional MySQL CREATE TABLE, CREATE FUNCTION, CREATE
TRIGGER, INSTALL COMPONENT, LOAD XML, GET DIAGNOSTICS and SELECT syntax -
[#40120](https://github.com/apache/shardingsphere/pull/40120)
1. Metadata: Support view table type in openGauss meta data loader -
[#39097](https://github.com/apache/shardingsphere/pull/39097)
1. Build: Support compiling and using ShardingSphere under OpenJDK 26 -
[#38625](https://github.com/apache/shardingsphere/issues/38625)
1. SQL Parser: Support Hive OPTIMIZE Statement about iceberg statement parse -
[#38877](https://github.com/apache/shardingsphere/pull/38877)
@@ -140,13 +137,13 @@
1. SQL Parser: Support MySQL Function statement parse -
[#38182](https://github.com/apache/shardingsphere/pull/38182)
[#38219](https://github.com/apache/shardingsphere/pull/38219)
1. SQL Parser: Support additional MySQL SELECT index hint and MATCH ...
AGAINST WITH ROLLUP syntax -
[#38233](https://github.com/apache/shardingsphere/pull/38233)
1. SQL Parser: Support MySQL CREATE EVENT and additional CREATE FUNCTION
RETURN syntax - [#38237](https://github.com/apache/shardingsphere/pull/38237)
-1. SQL Parser: Support MySQL subquery table projection alias visit to SQL
statement - [#38320](https://github.com/apache/shardingsphere/pull/38320)
+1. SQL Parser: Support column alias lists for MySQL derived tables -
[#38320](https://github.com/apache/shardingsphere/pull/38320)
1. SQL Parser: Support Oracle Create TABLE sql statement parse -
[#38667](https://github.com/apache/shardingsphere/pull/38667)
1. SQL Parser: Enhance select window partition by order by, lead placeholder
parse - [#38392](https://github.com/apache/shardingsphere/pull/38392)
1. SQL Parser: Support MariaDB cycleClause, groupConcatLimitClause, MEDIAN
window function parse -
[#38579](https://github.com/apache/shardingsphere/pull/38579)
1. SQL Parser: Support mysql, doris insert & replace rows statement parse -
[#38585](https://github.com/apache/shardingsphere/pull/38585)
1. SQL Parser: Support Oracle model, pivot, XML and hierarchical query parsing
and binding - [#38689](https://github.com/apache/shardingsphere/pull/38689)
-1. SQL Parser: Preserve temporal literal text and raw value for MySQL and
Oracle date-time literal parsing -
[#38886](https://github.com/apache/shardingsphere/pull/38886)
+1. SQL Parser: Fix temporal literal handling when rewriting encrypted INSERT
VALUES statements for MySQL and Oracle -
[#38886](https://github.com/apache/shardingsphere/pull/38886)
1. SQL Parser: Support oracle insert into returning into item statement parse
- [#38902](https://github.com/apache/shardingsphere/pull/38902)
1. SQL Parser: Enhance Hive SQL parser to support CTE, lateral view, table
sampling, transform and set operations -
[#39008](https://github.com/apache/shardingsphere/pull/39008)
1. SQL Parser: Add Hive CTAS and window function parsing -
[#39188](https://github.com/apache/shardingsphere/pull/39188)
@@ -156,12 +153,12 @@
1. SQL Parser: Support Oracle database object DDL parsing -
[#39286](https://github.com/apache/shardingsphere/pull/39286)
1. SQL Parser: Support Oracle package routine name parsing and binding -
[#39607](https://github.com/apache/shardingsphere/pull/39607)
1. SQL Parser: Support parsing Oracle CREATE INDEX sql -
[#39292](https://github.com/apache/shardingsphere/pull/39292)
-1. SQL Parser: Support parsing Oracle CREATE INDEXTYPE sql and Add CREATE
INDEX/OPERATOR sql it test -
[#39302](https://github.com/apache/shardingsphere/pull/39302)
+1. SQL Parser: Support parsing Oracle CREATE INDEXTYPE sql -
[#39302](https://github.com/apache/shardingsphere/pull/39302)
1. SQL Parser: Support function table alias column parsing for PostgreSQL and
openGauss - [#39268](https://github.com/apache/shardingsphere/pull/39268)
-1. SQL Parser: Support MySQL and Oracle CTAS parsing and binding enhancements,
and Doris TABLE statement segment extraction -
[#39332](https://github.com/apache/shardingsphere/pull/39332)
+1. SQL Parser: Support MySQL and Oracle CTAS parsing and binding enhancements,
and Doris TABLE statement parsing -
[#39332](https://github.com/apache/shardingsphere/pull/39332)
1. SQL Parser: Support Oracle full width SQL symbols parsing -
[#39349](https://github.com/apache/shardingsphere/pull/39349)
1. SQL Parser: Support Oracle pseudo-record collection index parsing -
[#39566](https://github.com/apache/shardingsphere/pull/39566)
-1. SQL Parser: Support Oracle DML error logging parser model and binder -
[#39711](https://github.com/apache/shardingsphere/pull/39711)
+1. SQL Parser: Support Oracle DML error logging parsing and binding -
[#39711](https://github.com/apache/shardingsphere/pull/39711)
1. SQL Parser: Support Oracle PL/SQL syntax parsing and binding -
[#39723](https://github.com/apache/shardingsphere/pull/39723)
1. SQL Parser: Enhance Oracle PL/SQL and database-link parsing and SQL binding
- [#40207](https://github.com/apache/shardingsphere/pull/40207)
1. SQL Parser: Support scalar expressions in Oracle `IN` predicates -
[#39876](https://github.com/apache/shardingsphere/pull/39876)
@@ -171,14 +168,12 @@
1. SQL Binder: Support select order by index bind metadata -
[#38386](https://github.com/apache/shardingsphere/pull/38386)
1. SQL Binder: Support SQL bind when with temp table name is same with
physical table - [#38411](https://github.com/apache/shardingsphere/pull/38411)
1. SQL Binder: Support PostgreSQL whole-row projection binding -
[#39276](https://github.com/apache/shardingsphere/pull/39276)
-1. SQL Binder: Preserve parameter marker projection metadata in column binder
- [#39709](https://github.com/apache/shardingsphere/pull/39709)
-1. Metadata: Support Oracle dictionary views by adding SYS default system
schema and YAML definitions -
[#38388](https://github.com/apache/shardingsphere/pull/38388)
+1. SQL Binder: Preserve parameter marker projection metadata -
[#39709](https://github.com/apache/shardingsphere/pull/39709)
+1. Metadata: Support Oracle dictionary views in the SYS schema -
[#38388](https://github.com/apache/shardingsphere/pull/38388)
1. Metadata: Support parsing query properties from Oracle JDBC URLs -
[#38901](https://github.com/apache/shardingsphere/pull/38901)
1. JDBC: Support setMaxRows and getMaxRows method in jdbc when not execute SQL
- [#38337](https://github.com/apache/shardingsphere/pull/38337)
-1. JDBC: Support safe close statement manager -
[#38473](https://github.com/apache/shardingsphere/pull/38473)
-1. JDBC: Bump the ClickHouse JDBC Driver used by optional modules to version
`0.9.8` - [#38878](https://github.com/apache/shardingsphere/pull/38878)
+1. JDBC: Continue releasing statement resources after a close failure -
[#38473](https://github.com/apache/shardingsphere/pull/38473)
1. JDBC: Supports the use of local transactions for Presto in ShardingSphere
JDBC- [#38941](https://github.com/apache/shardingsphere/pull/38941)
-1. JDBC: Bump the ClickHouse JDBC Driver used by optional modules to version
`0.9.8` - [#38878](https://github.com/apache/shardingsphere/pull/38878)
1. Proxy: Support non column projection for MySQL prepared statement in Proxy
- [#38507](https://github.com/apache/shardingsphere/pull/38507)
1. Proxy: Support driverClassName config in proxy storage unit to solve mysql
and mariadb jdbc url conflict -
[#38582](https://github.com/apache/shardingsphere/pull/38582)
1. Proxy: Support Firebird prepared statement cache reuse for held connections
- [#38644](https://github.com/apache/shardingsphere/pull/38644)
@@ -190,12 +185,7 @@
1. Encrypt: Support SqlServer update statement for Specifying a view as the
target object when use encrypt feature -
[#38896](https://github.com/apache/shardingsphere/pull/38896)
1. Encrypt: Support SqlServer for Using the UPDATE statement with information
from another table when use encrypt feature -
[#38926](https://github.com/apache/shardingsphere/pull/38926)
1. Sharding: Fix HASH_MOD routing mismatch for same negative numeric values
across numeric Java types with compatibility switch
`normalize-numeric-int-range` -
[#38327](https://github.com/apache/shardingsphere/pull/38327)
-1. SQL Parser: Support parsing SYSTEM_USER in SQL92 dialect and bind it as a
niladic function instead of a column -
[#39102](https://github.com/apache/shardingsphere/pull/39102)
-1. E2E: Add Firebird to SQL E2E tests through ShardingSphere-Proxy
-1. Proxy: Simplify connection properties parsing and metadata loading in
Firebird - [#40323](https://github.com/apache/shardingsphere/pull/40323)
-1. Proxy: Simplify SQL dialect exception mapping in Firebird -
[#40312](https://github.com/apache/shardingsphere/pull/40312)
-1. Proxy: Simplify protocol codec and packets in Firebird -
[#40314](https://github.com/apache/shardingsphere/pull/40314)
-1. SQL Parser: Simplify SQL statement visitors in Firebird -
[#40315](https://github.com/apache/shardingsphere/pull/40315)
+1. SQL Parser: Support parsing and binding SYSTEM_USER expressions in SQL92 -
[#39102](https://github.com/apache/shardingsphere/pull/39102)
## Release 5.5.3
