v5.3.1

release notes

Published 3/3/2022

PatchContains new features

Release notes

Compatibility changes

Change the default value of the system variable tidb_analyze_version from 2 to 1 #31748
Since v5.1.4, if TiKV is configured with storage.enable-ttl = true, the requests from TiDB are rejected, because the TTL feature of TiKV only supports the RawKV mode #27303

Feature enhancements

Support partition pruning for the built-in IN expression in Range partition tables #26739
Improve the accuracy of tracking memory usage when IndexJoin is executed #28650

Bug fixes

Fix a memory leak bug that occurs when the system variable tidb_analyze_version is set to 2 #32499
Fix the issue that the MaxDays and MaxBackups configurations do not take effect for the slow log #25716
Fix the issue that executing the INSERT ... SELECT ... ON DUPLICATE KEY UPDATE statement gets panic #28078
Fix the wrong result that might occur when performing JOIN on ENUM type columns #27831
Fix the issue that INDEX HASH JOIN returns the send on closed channel error #31129
Fix the issue that using the BatchCommands API might block sending TiDB requests to TiKV in some rare cases #32500
Fix the issue of potential data index inconsistency in optimistic transaction mode #30410
Fix the issue that window functions might return different results when using a transaction or not #29947
Fix the issue that the length information is wrong when casting Decimal to String #29417
Fix the issue that the GREATEST function returns incorrect result that occurs when setting the tidb_enable_vectorized_expression vectorized expression to off #29434
Fix the issue that the optimizer might cache invalid plans for join in some cases #28087
Fix wrong results of the microsecond and hour functions in vectorized expressions #29244 #28643
Fix the TiDB panic when executing the ALTER TABLE.. ADD INDEX statement in some cases #27687
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

Bug fixes

Fix a memory leak bug that occurs when the system variable tidb_analyze_version is set to 2 #32499

Fix the issue that the MaxDays and MaxBackups configurations do not take effect for the slow log #25716

Fix the issue that executing the INSERT ... SELECT ... ON DUPLICATE KEY UPDATE statement gets panic #28078

Fix the wrong result that might occur when performing JOIN on ENUM type columns #27831

Fix the issue that INDEX HASH JOIN returns the send on closed channel error #31129

Fix the issue that using the BatchCommands API might block sending TiDB requests to TiKV in some rare cases #32500

Fix the issue of potential data index inconsistency in optimistic transaction mode #30410

Fix the issue that window functions might return different results when using a transaction or not #29947

Fix the issue that the length information is wrong when casting Decimal to String #29417

Fix the issue that the GREATEST function returns incorrect result that occurs when setting the tidb_enable_vectorized_expression vectorized expression to off #29434

Fix the issue that the optimizer might cache invalid plans for join in some cases #28087

Fix wrong results of the microsecond and hour functions in vectorized expressions #29244 #28643

Fix the TiDB panic when executing the ALTER TABLE.. ADD INDEX statement in some cases #27687

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