Unclaimed project
Are you a maintainer of shardingsphere? Claim this project to take control of your public changelog and roadmap.
Claim this projectChangelog
shardingsphere
Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.
Back to changelogAPI Changes
- Authority: Mark privilege provider ALL_PERMITTED as deprecated and will be removed in future
- DistSQL: Remove optional param usageCount from show storage units
- Readwrite-splitting: Change dataSources to dataSourceGroups for YAML
New Features
- Kernel: Add new doris, hive and presto sql parser module and database type
Enhancements
- DistSQL: Check privilege when registering or altering storage unit
- DistSQL: Check duplicate actual data nodes when creating or altering sharding table rule
- DistSQL: Add like support for show storage units
- DistSQL: Rollback if import database configuration failed
- DistSQL: add table type to result set of show logical tables
- SQL Parser: Support MySQL change replication with no server ids
- SQL Parser: Support MySQL row and column aliases with ON DUPLICATE KEY UPDATE
- SQL Parser: Support MySQL CALL sql with mysql prefix
- SQL Parser: Support MySQL create loadable function returns int/dec
- SQL Parser: Support parsing MySQL CREATE TABLESPACE/TABLE in Mysql-8
SQL Parser: Support parsing MySQL CREATE INDEX with ENGINE_ATTRIBUTESQL Parser: Support parsing MySQL LOAD DATA with @ variableSQL Parser: Support parsing MySQL START REPLICA statementSQL Parser: Support parsing MySQL json table functionSQL Parser: Add MySQL column not null SQL parsingSQL Parser: Add MySQL charset SQL parsingSQL Parser: Enhance mysql json function visit statement resultSQL Parser: Support PostgreSQL COLLATION and CONSTRAINT keywordsSQL Parser: Support PostgreSQL, openGauss function table and update from parseSQL Parser: Support CTE with PostgreSQL and openGaussSQL Parser: Optimize the timezone support of PostgreSQLDateValueParser.SQL Parser: Support PostgreSQL limit and offset as nullSQL Parser: Enhance Oracle update statement as alias parse and add test caseSQL Parser: Support Oracle column length unit type SQL parsingMetadata: Collect table type for PostgreSQLKernel: Support sql hint extract when sql contains dbeaver hint commentKernel: Add extract combine left select in extractFromSelectStatementWithoutProjection methodKernel: Add assisted node to create and delete databasesTransaction: Use same transaction type in one transaction in JDBC adapterTransaction: Support for switching transaction typesSQL Federation: Support sql federation bit_count function for mysqlSQL Federation: Improve atan and anan2 sql function for mysqlSQL Federation: Support federated query mysql bin functionSQL Federation: Support for federated query NOT operatorProxy: Make the results of show tables in orderProxy: Trigger metadata collection when creating and deleting database and tableProxy: Optimize Agent to support collecting metrics data from multiple data sources when used with DriverProxy Native: Add more graalvm reachability metadata for caffeine cacheSharding: Revise all local index for sharding table and add object uniqueness level spi to control index token generatorSharding: Add NullsOrderType.LOW and NullsOrderType.HIGH to handle NULL order by in sharding featureSharding: Add inline sharding algorithms match actual data nodes checkEncrypt: Add unsupported check for combine statement with encrypt columnsEncrypt: Support select distinct(column) encrypt rewrite and refactor SubstitutableColumnNameToken build logicEncrypt: Support like concat nested concat statement rewrite with encrypt featurePipeline: Add SHARDING_TOTAL_COUNT impl of JobExecutorServiceHandler to improve CPU core requirementPipeline: Support page query for inventory dumper and data consistency streaming queryPipeline: Use case-insensitive identifiers to enhance the table metadata loaderPipeline: Support primary key columns ordering for standard pipeline table metadata loaderBug Fixes
- DistSQL: Fix load single table error after creating logical data source
- DistSQL: Fix set default single table storage unit to random failed
- DistSQL: Fix set default single table storage unit to logical data source failed
- DistSQL: Fix NPE when import metadata
- SQL Parser: Support PostgreSQL do nothing conflict action
- SQL Parser: Fix oracle nvl function and interval hour parse error
- Metadata: Keep in-used storage node when unregister storage unit
- Metadata: Fixed the problem of missing storage unit when registering storage unit
- Kernel: Replace ThreadLocal with TransmittableThreadLocal in HintManager to support cross Thread usage
- Kernel: Use ConnectionPropertiesParser spi to parse jdbcUrl to solve oracle url parse error
- Kernel: Fix column count assert exception caused by postgresql system table judge
- SQL Binder: Add TableAvailable interface for CloseStatementContext, MoveStatementContext, FetchStatementContext and fix sql rewrite test case
- Transaction: Fix setSavepoint method invocation not cleaning up
- Transaction: Fix savepoint manager not cleaned up in distributed transactions
- Transaction: Fix transaction context not cleaned up when xa transaction is committed
- Transaction: Fix the issue that cursor is not rewritten
- SQL Federation: Fix federated query LocalDateTime conversion
- SQL Federation: Fix push down sql execute error when sql contains chinese character with sql federation
- SQL Federation: Fix federation query binary type data query
- SQL Federation: Fix null result in federated query for a single projected column
- SQL Federation: Fix sql federation unknown type exception caused by calcite wrong result type with bigint
- Proxy: Support binary type bool value in PostgreSQL
- Proxy: Support array type prepared param in PostgreSQL
- Proxy: Support binary protocol value for text array in PostgreSQL
- Proxy: Fix duplicate results when querying information_schema.SCHEMATA
- Proxy: Fix incorrect results for querying information_schema.SCHEMATA
- Proxy: Fix NPE when execute show table status
- Proxy: Fix no database selected exception occurs when show tables from db
- Proxy: Fix the error that the process does not exit after proxy startup fail
- Proxy: Fix the error that the persisted system metadata was not cleared after the database was deleted in the PostgreSQL scenario
- Proxy: Fix no database selected exception in the query SQL
- JDBC: Resolve the issue where "zip file closed" in versions prior to SpringBoot 2.3.
- JDBC: Fix the NPE when it does not contain a specified logic database in Driver.
- Sharding: Fix Sharding column not tracked through aliases
- Sharding: Fix alter view exception when config sharding rule and binding table rule
- Sharding: Fix is need accumulate logic
- Sharding: Fix the generated key column name case insensitivity error
- Encrypt: Fix show create table wrong result with encrypt when data type contains float
- Encrypt: Fix the issue where updating a non-encrypted table and using a subquery on an encrypted table.
- Encrypt: Add insert select rewrite for encrypt
- Pipeline: InventoryTaskSplitter compatible with
BigInteger primary key
- Pipeline: Fix default data source lost when create migration job