NextStack
EN 中

shardingsphere 5.5.0

minor PublishedApr 30, 2024 Sourceapache/shardingsphere Chinese translation

shardingsphere 5.5.0

API Change

  1. Proxy: Remove the outdated schemaName configuration of the Proxy
  2. Kernel: Remove the sqlCommentParseEnabled configuration in SQL Parser Rule to reduce code complexity
  3. SQL Parser: Consider removing sqlCommentParseEnabled config in SQLParser rule
  4. Federation: Add allQueryUseSQLFederation config for sql federation

Bug Fix

  1. Pipeline: Fix commit/rollback migration job doesn’t drop related consistency check job when check job is not completed
  2. Pipeline: Fix show consistency check status stop_time display
  3. Proxy: Restore original databaseName in connectionSession after unicast
  4. Proxy: Fix show tables can be executed without use database
  5. Proxy: Fix the incorrect current database after unicast routing
  6. Proxy: Fix the problem that show tables can be executed before use database
  7. Readwrite-splitting: Fix check exception when using shadow data source
  8. Governance: Fix thread blocking problem when create logic database for Etcd register center
  9. Governance：Fix register storage units and create feature rules failure when use Standalone mode
  10. MetaData: Fix database system schema is not built when create database
  11. Metadata: Fix NPE of system schema builder rule
  12. SQL Parser: Fix PostgreSQL NPE when parse columnRef
  13. SQL Parser: Fix npe cause by parse MySQL select window statement
  14. Sharding: Fix routing error when joining tables in uppercase
  15. Sharding: Fix drop sharding table exception when table name is uppercase
  16. Sharding: Fix generated key with upper case column name
  17. Federation: Fix Object ‘DUAL’ not found exception when execute select 1 from dual with sql federation
  18. Transaction: Fix xa auto commit in executeQuery
  19. Proxy: Fix multi statements with specified database name

Enhancement

  1. Pipeline: Improve CDC stability and performance
  2. Pipeline: MemoryPipelineChannel supports configurable zero queue size for less memory consumption
  3. Pipeline: Show dedicated error when mode type is not Cluster
  4. Authority: Add isSuper option for user
  5. Pipeline: Ignore error message in status DistSQL result on job cancelling
  6. DistSQL: Use JSON format to output props in RQL
  7. DistSQL: Optimize REFRESH DATABASE METADATA logic
  8. DistSQL: SHOW COMPUTE NODES supports JDBC nodes
  9. DistSQL: Optimize syntax of REFRESH DATABASE METADATA
  10. DistSQL: Optimize the output of SHOW TABLE METADATA
  11. Proxy: Add MySQL precompiled parameter verification to avoid turning on rewriteBatchedStatements=true when BenchmarkSQL connects to Proxy, causing an ArrayIndexOutOfBoundsException exception when the Proxy parameterCount exceeds 65535.
  12. SQL Parser: Add EOF to throw exception when parse distsql rollback migration statement
  13. SQL Parser: Support more plsql statement parse and add plsql parse assert logic
  14. SQL Parser: Support parse index hint
  15. SQL Parser: Support mysql intersect combine operation sql parse
  16. SQL Parser: Supoort parse chinese white space for oracle
  17. SQL Parser: Fix mysql TimeStampDiff function parse
  18. SQL Parser: Fix sqlServer unqualified shorthand parsing
  19. SQL Parser: Support sqlServer SEARCH unreserved word parsing
  20. SQL Parser: Add sql server MEMBER unreserved word
  21. Binder: Add ParameterMarkerSegmentBinder logic for Oracle MergeStatementBinder
  22. Federation: Support mysql cross join statement for sql federation
  23. Transaction: Add advice message in XATransactionCheckPrivilegeFailedException
  24. Sharding: Validate duplicate sharding actual data nodes
  25. Sharding: Support null condition value routing
  26. Proxy: Fix mysql client multi statements option in protocol

New Feature

  1. DistSQL: New syntax for query plugin (SPI) implementation
  2. DistSQL: New syntax for managing SQL_TRANSLATOR rule

Refactor

  1. JDBC: Merge shardingsphere-jdbc-core to shardingsphere-jdbc module
  2. Proxy: Rename server.yaml to global.yaml, config- to database- and keep compatible with old config
  3. Proxy: Rename config-xxx.yaml to database-xxx.yaml
  4. Proxy: Optimize MySQLComStmtPrepareExecutor logic
  5. Encrypt: Refactor encrypt interface and add encrypt algorithm metadata
  6. Infra: Create new algorithm module in infra and move snowflake, uuid to this module
  7. Infra: Modify unmarshal method to return a default object when yaml is empty
  8. Infra: Optimize StandardParameterBuilder logic

Source apache/shardingsphere · 5.5.0 · 2024-04-30 · upstream release

Mirrored verbatim for indexing. All rights belong to the upstream project.

Release notes are published by the upstream project and mirrored here for indexing. All rights belong to their authors.