NextStack
EN 中

shardingsphere 5.1.2

patch PublishedJun 17, 2022 Sourceapache/shardingsphere Chinese translation

shardingsphere 5.1.2

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

Change Log

  1. MILESTONE

Source apache/shardingsphere · 5.1.2 · 2022-06-17 · 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.