pingcap/tidb v5.3.0

tidb-server v5.3.0

on GitHub

Improvements

• Show the affected SQL statements in the debug log when the coprocessor encounters a lock, which is helpful in diagnosing problems #27718
• Support showing the size of the backup and restore data when backing up and restoring data in the SQL logical layer #27247
• Improve the default collection logic of ANALYZE when tidb_analyze_version is 2, which accelerates collection and reduces resource overhead
• Introduce the ANALYZE TABLE table_name COLUMNS col_1, col_2, ... , col_n syntax. The syntax allows collecting statistics only on a portion of the columns in wide tables, which improves the speed of statistics collection

Bug Fixes

• Fix an error that occurs during execution caused by the wrong execution plan. The wrong execution plan is caused by the shallow copy of schema columns when pushing down the aggregation operators on partitioned tables. #27797 #26554
• Fix the issue that plan-cache cannot detect changes of unsigned flags #28254
• Fix the wrong partition pruning when the partition function is out of range #28233
• Fix the issue that planner might cache invalid plans for join in some cases #28087
• Fix wrong index hash join when hash column type is enum #27893
• Fix a batch client bug that recycling idle connection might block sending requests in some rare cases #27688
• Fix the TiDB Lightning panic issue when it fails to perform checksum on a target cluster #27686
• Fix wrong results of the date_add and date_sub functions in some cases #27232
• Fix wrong results of the hour function in vectorized expression #28643
• Fix the authenticating issue when connecting to MySQL 5.1 or an older client version #27855
• Fix the issue that auto analyze might be triggered out of the specified time when a new index is added #28698
• Fix a bug that setting any session variable invalidates tidb_snapshot #28683
• Fix a bug that BR is not working for clusters with many missing-peer regions #27534
• Fix the unexpected error like tidb_cast to Int32 is not supported when the unsupported cast is pushed down to TiFlash #23907
• Fix the issue that DECIMAL overflow is missing in the %s value is out of range in '%s'error message #27964
• Fix a bug that the availability detection of MPP node does not work in some corner cases #3118
• Fix the DATA RACE issue when assigning MPP task ID #27952
• Fix the INDEX OUT OF RANGE error for a MPP query after deleting an empty dual table. #28250
• Fix the issue of false positive error log invalid cop task execution summaries length for MPP queries #1791
• Fix the issue of error log cannot found column in Schema column for MPP queries #28149
• Fix the issue that TiDB might panic when TiFlash is shuting down #28096
• Remove the support for insecure 3DES (Triple Data Encryption Algorithm) based TLS cipher suites #27859
• Fix the issue that Lightning connects to offline TiKV nodes during pre-check and causes import failures #27826
• Fix the issue that pre-check cost too much time when importing many files to tables #27605
• Fix the issue that rewriting expressions makes between infer wrong collation #27146
• Fix the issue that group_concat function did not consider the collation #27429
• Fix the result wrong that occurs when the argument of the extract function is a negative duration #27236
• Fix the issue that creating partition fails if NO_UNSIGNED_SUBTRACTION is set #26765
• Avoid expressions with side effects in column pruning and aggregation pushdown #27106
• Remove useless gRPC logs #24190
• Limit the valid decimal length to fix precision-related issues #3091
• Fix the issue of a wrong way to check for overflow in plus expression #26977
• Fix the issue of data too long error when dumping statistics from the table with new collation data #27024
• Fix the issue that the retried transactions' statements are not included in TIDB_TRX #28670
• Fix the wrong default value of the plugin_dir configuration 28084