PolarDB-X 2025 compute node release notes
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 | |
Improved subquery handling for the column-oriented index (CCI). It now supports decorrelating any type of subquery. | |
Now supports the MySQL 8.0 | |
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). | |
| |
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 | |
The | |
SQL Plan Management (SPM) adds support for the | |
In SQL Plan Management (SPM), the | |
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 |
Fixed an issue where an | |
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 | |
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 | |
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 | |
Fixed an issue where the | |
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 |
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 |
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 | |
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 | |
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 | |
Fixed an issue where the | |
Fixed an issue where an | |
Fixed an issue where the deadlock detection mechanism could fail in certain scenarios. | |
Fixed an issue where an | |
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 |
Release date: 2025-07-14
Product version: V2.5.0
Component version: 5.4.20
Category | Description |
New features and optimizations | The |
Added support for the | |
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 | |
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 |
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 | |
Fixed an issue where high-privilege accounts could not execute a | |
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 | |
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 | |
Fixed an issue where the auto-cleanup schedule for a table with cold data archiving enabled became invalid after a |
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 | |
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 | |
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 |
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 |
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 |
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 | |
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 | |
Fixed an issue where a CCI incorrectly deleted a local | |
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. | |
| |
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 | |
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 |
Fixed an issue that caused some | |
Fixed incorrect constraint behavior for a self-referencing foreign key when using an expression. | |
Fixed an infinite loop issue in | |
Fixed an issue that prevented the proper cleanup of histogram statistics for non- | |
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 | |
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 | |
Fixed an issue that caused point queries using execution plan transfer to return incorrect results for | |
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 | |
Fixed an issue where a DML operation failed on a | |
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 |
Release date: 2025-03-05
Product version: V2.4.0
Component version: 5.4.19
Category | Description |
New features and optimizations | Added support for |
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 | |
Bug fixes | Fixed an issue where |
Fixed an issue where the previous primary key value was incorrect after an | |
Fixed an issue where automatic table group merge did not take effect after an | |
Fixed an issue where executing a | |
Fixed an issue where the | |
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 | |
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 | |
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 | |
Fixed an issue where residual metadata remained after a CCI was deleted. | |
Fixed an issue where a | |
Fixed an issue where a | |
Fixed an issue where the system failed to promptly release the MetaDB lock after the connection for a running | |
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 | |
Fixed an issue where a | |
Fixed an issue where execution could fail when using | |
Fixed an issue where the constraint check was incorrect when a foreign key was | |
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 |
Added support for processing both | |
Tables with a columnar index (CCI) now support more | |
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 | |
Optimize query performance for large | |
Optimized the display of | |
Optimized the performance of | |
Bug fixes | Fixed an issue where |
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 | |
Fixed an issue that caused | |
Fixed a performance degradation issue with | |
Fixed an issue where the automatic merging of table groups failed after an | |
Fixed an issue where repartition MPP execution caused duplicate metadata for a secondary index. | |
Fixed an issue where the | |
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 | |
Fixed an issue with foreign key constraint checks when an | |
Fixed an issue where using | |
Fixed an issue where a CASCADE foreign key could cause an error when an | |
Fixed an issue where using | |
Fixed an issue where SQL Plan Management (SPM) was not persisted to disk correctly after a table | |
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 | |
Fixed a query error caused by the CBOJoinWindowTransposeRule. | |
Fixed an issue where an | |
Fixed a template mismatch issue caused by | |
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 | |
Fixed an issue that caused queries on | |
Fixed inconsistent table name casing in Columns metadata. | |
Fixed an issue where the | |
Fixed an issue where |
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 | |
You can now process | |
| |
Optimized the statistics Cardinality interface for more accurate cost calculations. | |
Optimized the logic for converting a logical | |
Optimized the automatic period adjustment for scheduled statistics tasks during upgrades or restarts. | |
Optimized the transaction policy to support | |
Optimized the display of | |
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 | |
Fixed a transaction leak related to columnar indexes on read-only instances. | |
Fixed an issue where the | |
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 | |
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 | |
Fixed a scan failure for an HLL task caused by the case of a column name. | |
Fixed an issue where the | |
Fixed an issue where a query on | |
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 | |
Fixed an issue where partition routing failed for the | |
Fixed an issue with | |
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 | |
Fixed an issue with inconsistent casing of table names in Columns metadata. | |
Fixed an issue that could cause incorrect metadata when multiple | |
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 |
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 | |
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 | |
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 | |
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 | |
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. |