PolarDB-X 2025 compute node release notes

Updated at:

This topic lists the 2025 release notes for compute nodes (CN) in PolarDB-X instances.

Release date: 2025-12-17

Product version: V2.5.0

Component version: 5.4.21

Category

Description

New features and optimizations

Optimized query performance in Top-N per group scenarios.

Now supports loading incremental files directly from columnar nodes. This significantly reduces the overhead of cold-loading incremental data.

A new enable_partition_wise configuration is added to centrally manage the Partition-Wise mode.

Improved subquery handling for the column-oriented index (CCI). It now supports decorrelating any type of subquery.

Now supports the MySQL 8.0 sql_mode value TIME_TRUNCATE_FRACTIONAL.

Bug fixes

DDL interruptions or rollbacks no longer break replication on a row-based read-only instance.

The recycle bin feature no longer returns a "not supported" error for tables with a global secondary index (GSI).

INSERT operations no longer fail when a logical generated column's expression contains a NULL value.

The lock-free change column type feature no longer fails when you add a new column before the primary key.

Release date: 2025-10-14

Product version: V2.5.0

Component version: 5.4.20

Category

Description

New features and optimizations

Added support for cold data archiving (TTL) based on integer types in specific date formats.

You can now use the CHANGE COLUMN syntax to modify the primary key column name for single tables and broadcast tables.

The ALTER USER ... LOCK/UNLOCK syntax is introduced for database account management. This feature provides a standard SQL method to lock and unlock user accounts. You can use it to prevent brute-force password attacks or perform temporary account control, which improves database security.

SQL Plan Management (SPM) adds support for the BASELINE FIX EXPR directive, which allows you to manually control the parameter space to select different execution plans.

In SQL Plan Management (SPM), the BASELINE DELETE command synchronizes the corresponding execution plan in the plan cache.

Optimized the partition-based cleanup mechanism for cold data archiving (TTL) to support the recycle bin by default.

Optimized the interaction logic between the columnar index (CCI) and cold data archiving (TTL). When a TTL table without a columnar index is accessed in a read-only columnar instance, queries are automatically routed to its corresponding columnar archive table.

Bug fixes

Fixed an issue where the connection count monitoring metric for the polardbx library might show a negative number in specific scenarios.

Fixed an issue where an ADD COLUMN operation on a table with a clustered index might fail unexpectedly.

Fixed inaccurate connection count monitoring.

Fixed an issue where creating a Range/List partitioned table failed if the partition boundary value definition contained escape characters.

Fixed case-sensitivity issues with columnar index (CCI) names.

Fixed an issue where the GET_LOCK() function returned an unexpected result when the timeout parameter is 0.

Fixed a bug where the metadata lock (MDL) deadlock detection mechanism could fail.

Fixed an issue where using a common table expression (CTE) in an INSERT ... SELECT statement involving only a single table could cause an execution error.

Fixed an issue where a range scan query could fail under the Read Committed transaction isolation level.

Fixed a bug that caused the MPP service process on a compute node (CN) to get stuck during startup.

Fixed a failure when using the lock-free schema change feature to add a column before the primary key.

Fixed an issue where the information_schema.partitions view displayed incorrect information when you query single tables or broadcast tables.

Fixed an issue where the getColumnName method failed to correctly return the column name defined in the table.

Fixed a bug where a data node (DN) could fail if a high availability (HA) switchover occurred during a compute node (CN) cold start.

Fixed a bug where new configuration for a cold data archiving (TTL) task did not take effect immediately after its schedule time was modified.

Corrected the error code returned in deadlock scenarios. The internal error code 4614 has been changed to 1213.

Fixed sharding algorithms from DBLE that incorrectly handled invalid integer values.

Fixed an error in MySQL 5.7 compatibility mode that could occur when a query with a common table expression (CTE) was pushed down to a single table on a data node (DN).

Fixed an issue where the LOAD DATA statement did not support using double backticks to quote column names.

Release date: 2025-09-23

Product version: V2.5.0

Component version: 5.4.19

Category

Description

New features and optimizations

Added support for creating multiple columnstore indexes (CCIs) on a data table.

Added support for explicitly creating an archive type for CCIs.

Added support for sorting CCIs in descending order by sort key.

Added support for creating prefix indexes on global secondary indexes (GSIs).

Added support for cold data archiving (TTL) based on integer types with a specific date format.

DDL operations for hot spot partition splitting now support asynchronous multi-write optimization.

Optimized the progress display and execution performance of the full data pull for CCIs.

Optimized the historical data migration mechanism during logical DDL execution to reduce lock contention.

Optimized the default row-based cleanup policy for TTL. The cleanup task now processes only expired data with non-NULL values in the time column. This prevents the accidental cleanup of rows where the time column is NULL, improving the accuracy and integrity of data operations.

Bug fixes

Fixed a bug where an INSERT ON DUPLICATE KEY UPDATE statement failed when updating a TIMESTAMP NOT NULL column with a zero-value time string, caused by the DYNAMIC IMPLICIT DEFAULT detection mechanism.

Fixed an issue where the scheduled auto-cleanup task for a table with TTL enabled stopped running after a RENAME operation.

Fixed an issue where a view's execution plan was not updated synchronously after a DDL operation on its base table, which caused subsequent queries to fail or return incorrect results.

Fixed an issue that caused incorrect query results due to a parameter parsing error. The error occurred when a client sent a TIMESTAMP parameter with a fractional part less than 0.1 through the PreparedStatement interface.

Fixed an issue where changes to a TTL task's scheduling policy did not take effect immediately.

Fixed an issue where the deadlock detection mechanism for the metadata lock (MDL) could fail in certain high-concurrency scenarios.

Fixed an issue where paged queries using PAGING_FORCE returned incorrect results in single-shard query scenarios.

Fixed an issue where a range scan query could cause an error at the Read Committed transaction isolation level.

Fixed an issue where creating multiple CCIs for a single data table failed under specific conditions.

Fixed an issue where the CHECK GLOBAL INDEX command could not detect inconsistencies in global secondary indexes (GSIs) in certain scenarios.

Fixed an issue where the CREATE VIEW statement incorrectly omitted the PARTITION syntax or PARTITION_HINT specified for a partitioned table.

Fixed an issue where an ADD COLUMN operation on a table that already had a clustered index could unexpectedly fail in certain scenarios.

Fixed an issue where the deadlock detection mechanism could fail in certain scenarios.

Fixed an issue where an INSERT ... SELECT statement on a single table failed when the SELECT clause used a common table expression (CTE).

Fixed an issue where the lockless column type change feature failed to process a column with a prefix index due to a compatibility problem.

Fixed an issue where an incorrect SQL statement was pushed down to a data node when an INSERT statement assigned a NULL value to a TIMESTAMP column in multi-write optimization scenarios.

Release date: 2025-07-14

Product version: V2.5.0

Component version: 5.4.20

Category

Description

New features and optimizations

The CREATE VIEW statement now supports the PARTITION clause. This allows you to create a view based on specific partitions of a partitioned table.

Added support for the ALTER USER ... ACCOUNT LOCK/UNLOCK syntax. This allows database administrators to manually lock or unlock an account, enhancing database security and helping prevent malicious login attempts such as brute-force attacks.

Added support for modifying the partition keys and sort keys of a CCI. This allows you to adjust the data distribution and sort strategy of a CCI to reflect business changes without a full index rebuild, thereby optimizing query performance.

Added support for the in-place rebuilding of a CCI. This allows you to optimize and reorganize a CCI without affecting queries or access to historical data versions.

DRDS mode now supports route computation for expressions.

Optimized lock contention between business DML operations and data source switching during data balancing in DRDS mode.

Optimized the migration process for existing data in DDL operations that use logical execution to reduce lock contention.

Enhanced the DDL engine to provide concurrency and idempotency control for DDL statements in dry run mode.

Optimized the execution process for deleting a CCI.

Bug fixes

Fixed an issue where the forced acquisition mechanism for a physical metadata lock (MDL) could fail after a DROP DATABASE operation.

Fixed an issue where paged queries returned incorrect results in single-shard scenarios.

Corrected the return code for deadlock errors from 4614 to 1213.

Fixed an issue that prevented the automatic collection of HyperLogLog statistics for tables that contain a CCI.

Fixed an issue where partition pruning for an IN condition could cause an error in high-concurrency transaction scenarios.

Fixed an issue where high-privilege accounts could not execute a GRANT ROLE statement.

Fixed a rare issue where a data consistency lock for a CCI could not be correctly released.

Fixed an issue that prevented the export of the binary log from a read-only instance.

Fixed an issue where the sequence for the statistics system table lagged.

Fixed an issue where the rescheduling mechanism for SQL throttling failed.

Fixed an issue where upgrades could fail because GDN encountered an error when creating a system table in the global meta service.

Fixed an issue where a CREATE VIEW statement would lose the PARTITION clause and PARTITION_HINT when defined for a partitioned table.

Fixed an issue where the CHECK GLOBAL INDEX command failed to detect inconsistencies in a global secondary index in certain scenarios.

Fixed an issue where a window function could cause a NullPointerException in JoinTableLookupTransposeRule.

Fixed an issue where the auto-cleanup schedule for a table with cold data archiving enabled became invalid after a RENAME operation.

Release date: 2025-06-19

Product version: V2.4.0

Component version: 5.4.19

Category

Description

Optimizations

Optimized the idempotency check logic for the migration task when modifying the Locality property of a table group.

Improved scaling performance for tables with small data volumes.

Optimized lock contention between DML operations and data source switching during data balancing for databases in DRDS mode.

Bug fixes

Removed the EXPAND keyword.

Fixed a lock leak in the columnar engine caused by a deadlock.

Fixed partition pruning failures for IN statements in high-concurrency transaction scenarios.

Fixed an issue that prevented the binary log from being dumped from a read-only instance.

Fixed database creation failures caused by uppercase letters in storage pool names.

Fixed a query error caused by automatic FORCE INDEX on a full-text index table.

Fixed an issue where forced acquisition of a physical metadata lock (MDL) could fail after database deletion.

Fixed an incorrect pushdown that could occur when joining a single table with a subquery in a cross-database scenario.

Fixed an incorrect pushdown in multi-write scenarios caused by assigning a NULL value to a TIMESTAMP column in an INSERT statement.

Fixed a metadata error that occurred during the scale-in of multiple data nodes (DNs) for a logical database whose Locality directly declares the storage nodes.

Fixed failures of UPSERT/REPLACE/INSERT IGNORE statements on MySQL 8.0 data nodes (DNs) caused by a type conversion error.

Release date: 2025-05-19

Product version: V2.5.0

Component version: 5.4.20

Category

Description

New features and optimizations

Baselines now support the DELETE_UNFIXED instruction to delete all baselines that are not fixed and have not evolved from hot spots.

Baselines now support versioning. Plans generated by new versions cannot be used by older nodes.

GSIs now support prefix indexes.

The system now supports converting non-scalar subqueries that contain LIMIT/ORDER BY to SEMI JOINs.

Range partitions now support dynamic paging pruning in paging scenarios.

The system now supports DRYRUN rewrites for DDLs that only refresh metadata.

Broadcast tables with Locality now support join pushdown execution.

SESSION HINT now supports processing broadcast tables in DRDS mode databases.

Optimized the default row-based TTL cleanup policy to remove only expired data with non-NULL values.

Optimized the pushdown of non-correlated scalar subqueries.

Optimized the scaling logic for tables with small data volumes.

Improved the performance of SQL optimization pruning on IN clauses with a large number of parameters.

Removed the EXPAND keyword.

Bug fixes

Fixed the BlackHoleBlockBuilder cannot be cast to class DecimalBlockBuilder error in Range Scan.

Fixed transient disconnections and service traffic fluctuations during operations and maintenance (O&M) on underlying storage nodes.

Fixed a bug where adding a column to a table with a clustered index would fail.

Fixed an issue where the ORDER BY clause in the GROUPCONCAT() function did not support parameterization.

Fixed a bug causing incorrect pushdowns for subquery-based joins on a single table in a cross-database scenario.

Fixed foreign key-related errors that occurred during partition changes.

Fixed an issue where ENABLE_JAVA_UDF did not support dynamic switching.

Fixed an issue where the optimizer would run out of memory (OOM) when parsing a large number of subqueries.

Fixed a compatibility issue between the lockless column type change feature and prefix indexes.

Fixed an issue where an asynchronous prefetching thread could corrupt in-memory metadata. This occurred when the thread started prefetching a database after the database had been deleted.

Fixed an issue where automatic FORCE INDEX on a full-text index table caused a query to fail.

Fixed an issue where a CCI caused the loss of a local AUTO_SHARD_KEY index.

Fixed a bug where using a time partition function on an integer partition key column in a hash partition, range partition, or list partition failed to report an error.

Fixed a bug that prevented some DDL connections waiting for resource locks from being killed during a batch commit of DDL tasks.

Fixed a lock leak in the columnar engine caused by a deadlock.

Fixed an issue where a pushed-down column subquery failed when executed with an IN expression.

Release date: 2025-04-15

Product version: V2.4.0

Component version: 5.4.19

Category

Description

Optimization

Optimized transaction blocking logic. The server now automatically disconnects a client if its transaction stalls or cannot be committed. This optimization applies only to new instances.

Bug fixes

Fixed an execution hang that occurred when using PartitionWise Join with Broadcast Shuffle in massively parallel processing (MPP) mode.

Fixed an execution hang that occurred with some JOIN queries in MPP mode.

Fixed an issue where a CCI incorrectly deleted a local AUTO_SHARD_KEY index.

Fixed an issue where the SHOW DDL statement reported incorrect data backfill progress.

Fixed issues such as transient disconnections and service traffic jitter during operations and maintenance (O&M) on underlying storage nodes.

Release date: 2025-03-28

Product version: V2.5.0

Component version: 5.4.20

Category

Description

New features and optimizations

The Fix instruction in SQL Plan Management (SPM) now supports binding executor parameters.

SPM now supports anomaly alerts.

Multi-stream binary logging in change data capture (CDC) now supports one binary log stream per storage node.

Added support for the GB18030-2022 character set.

DDL operations for hot spot partition splitting now support asynchronous multi-write optimization.

SORT KEY pruning now applies to the TINYINT and TIMESTAMP data types.

You can now use CHECK TABLE to verify the consistency of Global Primary Partitioning (GPP) properties for secondary indexes.

Optimized the metadata space usage of columnstore index snapshots.

Optimized the data display in Information_schema.tables.

Optimized the backfill performance of symmetric replication during a lockless column type change.

Optimized the performance of paged queries.

Index merge now applies to more scenarios.

Bug fixes

Fixed an issue that caused an incorrect previous primary key value after executing an INSERT IGNORE statement.

Fixed an issue that caused some JOIN queries to hang in Massively Parallel Processing (MPP) mode.

Fixed incorrect constraint behavior for a self-referencing foreign key when using an expression.

Fixed an infinite loop issue in JoinPushTransitivePredicatesRule.

Fixed an issue that prevented the proper cleanup of histogram statistics for non-VARCHAR columns.

Fixed an occasional sharding calculation error in high-concurrency scenarios.

Fixed an issue causing queries on columnar data to fail if the data contained an oversized column.

Fixed an issue that caused incorrect SORT WINDOW results when using a columnstore index.

Fixed excessive initial capacity of the hash table for an aggregation operator in non-MPP mode.

Fixed an issue that could cause a PAUSE DDL statement to time out.

Fixed an issue that could cause failures when creating a global secondary index on a BIT column with special values like 0x32.

Fixed an issue that caused point queries using execution plan transfer to return incorrect results for UTF-8 encoded index columns.

Fixed an issue where a lock was not automatically released if a database connection was closed while a database-level DDL statement was running.

Fixed an issue that allowed a TRUNCATE TABLE operation on a foreign key parent table containing a global secondary index.

Fixed an issue that prevented DELETE statements from being pushed down during row-based cleanup on TTL subpartitioned tables.

Fixed an issue where a DML operation failed on a JSON column that contained NULL values.

Fixed an issue that left residual metadata after deleting a columnstore index.

Fixed an issue where smart routing incorrectly selected an archived table.

Fixed an issue that prevented JOIN pushdown in full aggregation pushdown scenarios using cost-based optimization (CBO).

Release date: 2025-03-05

Product version: V2.4.0

Component version: 5.4.19

Category

Description

New features and optimizations

Added support for SORT KEY pruning for the TINYINT and TIMESTAMP data types.

DMS now supports executing lockless change statements.

Added support for using CHECK TABLE to check the property consistency of Global Primary Partitioning (GPP) for secondary indexes.

Optimized metadata space usage for the columnstore snapshot feature.

Optimized the performance of paged queries.

Optimized the backfill performance of symmetric replication during a lockless column type change.

Expanded support for index merge scenarios.

Optimized the performance of SELECT DISTINCT statements in timestamp oracle (TSO) transactions.

Bug fixes

Fixed an issue where UPSERT/REPLACE/INSERT IGNORE statements failed on a MySQL 8.0 data node due to a type conversion error.

Fixed an issue where the previous primary key value was incorrect after an INSERT IGNORE statement was executed.

Fixed an issue where automatic table group merge did not take effect after an ALTER TABLE MOVE PARTITION operation.

Fixed an issue where executing a RENAME TABLE statement using a reused connection caused a non-preemptive metadata lock (MDL).

Fixed an issue where the SHOW DDL statement displayed an inaccurate data backfill progress.

Fixed an issue where the initial capacity of the hash table for an aggregation operator was too large in non-MPP mode.

Fixed an issue where SORT WINDOW results were incorrect after a CCI was used.

Fixed an occasional sharding calculation error in high-concurrency scenarios.

Fixed an issue where a point query using execution plan transfer returned incorrect results if the index column was encoded as a UTF-8 string.

Fixed an issue where a query that used columnar data failed if the data contained an oversized single column.

Fixed an issue where the system failed to automatically release a lock after a connection for a running database-level DDL statement was closed.

Fixed an issue where a DML operation failed on a JSON-type column that contained NULL values.

Fixed an issue where creating a global secondary index (GSI) for a BIT column that contained special values, such as 0x32, could fail.

Fixed an issue where residual metadata remained after a CCI was deleted.

Fixed an issue where a JOIN operation could not be pushed down in a full aggregate function pushdown scenario of Cost-Based Optimization (CBO). For more information, see Advanced SQL tuning.

Fixed an issue where a TRUNCATE TABLE operation was not blocked on a foreign key parent table that contained a GSI.

Fixed an issue where the system failed to promptly release the MetaDB lock after the connection for a running CREATE DB/DROP DB statement was interrupted.

Fixed an issue where an execution timeout could occur when a PAUSE DDL statement was executed.

Fixed an issue where a CASCADE operation on a foreign key could fail when an ON DUPLICATE KEY UPDATE statement was executed on the parent table.

Fixed an issue where a DELETE statement was not directly pushed down during row-based cleanup on a TTL table that was a subpartitioned table.

Fixed an issue where execution could fail when using INSERT SELECT with ON DUPLICATE KEY UPDATE.

Fixed an issue where the constraint check was incorrect when a foreign key was UPDATEd to a NULL value.

Fixed an issue where a Change Data Capture (CDC) rewrite failed for a foreign key name that contained special characters, such as ~#@.

Release date: 2025-01-22

Product version: V2.5.0

Component version: 5.4.20

Category

Description

New features and optimizations

The CHECK TABLE statement for DRDS databases now supports checking the integrity and consistency of a local index. For more information, see CHECK TABLE.

Added support for processing both SCAN HINT and DML in a transaction. 

Tables with a columnar index (CCI) now support more Modify/Change Column types. For more information, see DDL statement limits for CCIs.

Logical DML statements now support using a global secondary index (GSI) with primary key partitioning to detect primary key conflicts.

Optimized the cardinality interface for statistics collection to provide more accurate cost estimates.

Optimized the progress display and performance of the full data pull process for CCIs.

Optimized the automatic period adjustment for scheduled statistics tasks during an upgrade or restart.

Optimized the conversion logic from logical IN Values queries to physical UNION ALL operations.

Optimize query performance for large IN clauses on columnstore indexes.

Optimized the display of SHOW DDL RESULT.

Optimized the performance of BATCH INSERT data imports when values are specified for auto_increment columns.

Bug fixes

Fixed an issue where INSERT statements containing NULL values caused the PlanCache to become full.

Fixed a variable leak that occurred when setting the Archive transaction policy at the session level. Database accounts with standard permissions can now set the transaction policy for the current transaction to Archive.

Fixed an issue where executing RENAME TABLE on a reused connection caused a non-preemptive MDL (Metadata Lock).

Fixed an issue that caused UPSERT/REPLACE/INSERT IGNORE statements to return an error on version 8.0 DNs (data nodes) due to type conversion.

Fixed a performance degradation issue with SELECT DISTINCT in TSO transactions.

Fixed an issue where the automatic merging of table groups failed after an ALTER TABLE MOVE PARTITION operation.

Fixed an issue where repartition MPP execution caused duplicate metadata for a secondary index.

Fixed an issue where the now() function rounded up.

Fixed an issue that prevented the DDL Engine from cleaning up a job. This occurred because the DDL cleanup process cleaned up a subtask before its parent task.

Fixed an issue where the tx_read_only variable returned an incorrect value in a read-only instance.

Fixed an issue with foreign key constraint checks when an UPDATE statement sets the key to NULL.

Fixed an issue where using INSERT SELECT with ON DUPLICATE KEY UPDATE could cause an execution failure.

Fixed an issue where a CASCADE foreign key could cause an error when an ON DUPLICATE KEY UPDATE statement is executed on the parent table.

Fixed an issue where using KILL on a connection that was executing CREATE DB/DROP DB did not release the MetaDB lock in a timely manner.

Fixed an issue where SQL Plan Management (SPM) was not persisted to disk correctly after a table DROP execution plan.

Fixed an issue where a log node (CDC) failed to rewrite a foreign key name that contains special characters, such as ~#@.

Fixed a scan failure for a HyperLogLog (HLL) task caused by the column name's case.

Fixed an issue where creating multiple CCIs for a single table failed.

Fixed an issue where the permission check for UPDATE JOIN was incomplete.

Fixed a query error caused by the CBOJoinWindowTransposeRule.

Fixed an issue where an IN expression failed in a cross-database query.

Fixed a template mismatch issue caused by IN parameter pruning during batch DML processing in non-proprietary protocol mode.

Fixed an issue where a physical replication task caused a physical SQL statement to fail when processing a special table name.

Fixed an execution failure caused by an executor sharding calculation error during a DDL change.

Fixed an issue where non-leader nodes could not find tables when table creation and database initialization ran concurrently.

Added support for CHECK TABLE to check the GPP attribute consistency of a secondary index.

Fixed an issue that caused queries on information_schema.columns to fail when filtering the column_default column.

Fixed inconsistent table name casing in Columns metadata.

Fixed an issue where the CONVERT function in a subquery failed to recognize correlated columns.

Fixed an issue where JOIN operations on columns with the same name returned misaligned column names.

Release date: 2025-01-16

Product version: V2.4.0

Component version: 5.4.19

Category

Description

New features and optimizations

Added a columnar index inspection task to compress stale CSV files.

Logical DML now supports using a GSI with primary key partitioning to detect primary key conflicts.

DRDS databases now support Check Table to check the integrity and consistency of a LOCAL INDEX. For more information, see CHECK TABLE.

You can now process SCAN HINT and DML together in a transaction. 

CHECK TABLE now supports checking the GPP property consistency of a secondary index.

Optimized the statistics Cardinality interface for more accurate cost calculations.

Optimized the logic for converting a logical IN Values query into a physical UNION ALL operation.

Optimized the automatic period adjustment for scheduled statistics tasks during upgrades or restarts.

Optimized the transaction policy to support SET drds_transaction_policy=archive.

Optimized the display of SHOW DDL RESULT.

Optimized the conversion of a single table into a single-partition partitioned table. This operation now improves performance by modifying only metadata without data migration.

Bug fixes

Fixed an issue where CBOJoinWindowTransposeRule caused a query error.

Fixed an issue where INSERT statements containing NULL values caused the PlanCache to become full.

Fixed a transaction leak related to columnar indexes on read-only instances.

Fixed an issue where the now() function would round up.

Fixed an issue where Repartition MPP execution caused duplicate metadata for a secondary index.

Fixed an issue that prevented the DDL Engine from cleaning up a job. This issue occurred because the DDL cleanup process removed a subtask before its parent task.

Fixed an issue where using the KILL command on a connection that was executing CREATE DB/DROP DB failed to release the MetaDB lock in a timely manner.

Fixed a template mismatch issue caused by IN parameter pruning during batch DML processing in non-proprietary protocol mode.

Fixed an issue where SPM data was not correctly persisted to disk after a table's execution plan was dropped.

Fixed an issue where the permission check for UPDATE JOIN was incomplete.

Fixed a scan failure for an HLL task caused by the case of a column name.

Fixed an issue where the IN expression failed to execute in cross-database queries.

Fixed an issue where a query on information_schema.columns failed when filtering the column_default column.

Fixed an execution failure caused by an incorrect sharding calculation from the executor during a DDL change.

Fixed a physical replication failure that occurred when executing SQL on tables with names containing special characters.

Fixed an issue where a non-leader node could not find a table. This occurred when a table was created concurrently with database initialization.

Fixed an issue that caused scaling tasks to pause during incremental data synchronization due to incorrect character set handling for string types.

Fixed an issue where correlated items in the CONVERT function of a subquery were not correctly recognized.

Fixed an issue where partition routing failed for the Timestamp type with high precision.

Fixed an issue with JSON_SET's handling of string types.

Fixed an issue where related plans were not automatically rebuilt when a table's metadata was changed while a baseline was fixing a view.

Fixed an issue where a JOIN on columns with the same name returned incorrect column names.

Fixed an issue with inconsistent casing of table names in Columns metadata.

Fixed an issue that could cause incorrect metadata when multiple ALTER MODIFY TTL statements concurrently modify the parameters of a TTL table.

Fixed an issue where a fixed baseline plan became invalid because the number of execution errors exceeded the threshold.

Release date: 2024-12-24

Product version: V2.5.0

Component version: 5.4.20

Category

Description

New features and optimizations

A new INFORMATION_SCHEMA.DDL_INFO view is added, allowing you to query the status and other information of all DDL operations to help external systems, such as DMS and GDN, determine DDL idempotency.

Read-only columnstore index instances now support transactions. Queries within a transaction access the same consistent snapshot.

Added support for database-level batch operations on columnstore indexes.

Data tables now support multiple columnstore indexes.

Added a columnstore index inspection task to compress inactive CSV files.

Added support for CHECK constraints.

Vectorized IN expressions now support dictionary encoding.

Added support for parallel sort window execution optimization.

Added support for the INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES view.

Optimized task allocation load balancing on multiple nodes in the DDL MPP scheduler.

Optimized queries on read-only columnstore index instances by enabling early stream termination in some scenarios.

Optimized the result display for EXPLAIN ANALYZE statements to include the number of I/O bytes for exchange and oss table scan.

Optimized the performance of paged queries.

Optimized the metadata space usage of columnstore index snapshots.

Expanded support for index merge scenarios.

Bug fixes

Fixed a columnar transaction leak issue on a read-only columnstore index instance.

Fixed an issue where table creation failed because an enumerated value for the ENUM type in the table creation statement contained a comma ,.

Fixed a bug in how JSON_SET handled string types.

Fixed excessive space usage caused by repeated serialization of a statistics histogram.

Fixed a bug that prevented baseline deletion when a write request was received during the process.

Fixed an issue that caused incorrect metadata when multiple ALTER MODIFY TTL statements were run concurrently to modify TTL table parameters.

Fixed an issue with data collection for a column that had the same name as a HyperLogLog (HLL) reserved word.

Fixed an issue where partition routing failed for a Timestamp type with high precision.

Fixed failures in Truncate/Drop partition operations on tables without a GSI or CCI. This issue occurred if another table in the same table group contained a GSI or CCI.

Fixed an issue where a Baseline Hint Bind became invalid due to a change in the table schema.

Fixed a scaling bug where an error in character set processing paused tasks during incremental data synchronization.

Fixed a bug that prevented the automatic rebuilding of related plans when a table's metadata changed while a baseline was fixing a view.

Fixed a bug that caused tables with a global clustered index to lose local indexes after a lockless column type change.

Fixed a bug that invalidated fixed baseline plans when the number of execution errors exceeded the threshold.