pingcap/tidb v5.1.2

tidb-server v5.1.2

on GitHub

Improvements

• Trigger auto-analyze by histogram row count, increase the accuracy of this trigger action #24237
• Push down mod() to TiFlash, increase the query performance. #2318

Bug Fixes

• Fix the potential wrong results of index hash join when the hash column is in the ENUM type #27893
• Fix a batch client bug that recycle idle connection may block sending requests in some rare cases #27678
• Fix the compatibility issue of the overflow check by keeping the same logic as MySQL #23897
• Fix the issue that TiDB returns an unknow error while it should return the pd is timeout error #26147
• Fix the error of the case when function caused by the wrong charset and collation #26662
• Fix the issue that greatest(datetime) union null returns an empty string #26532
• Fix the potential can not found column in Schema column error for MPP queries #28148
• Fix a bug that TiDB may panic when TiFlash is shutting down #28096
• Fix the issue of wrong range caused by using enum like 'x%' #27130
• Fix the issue that the between expression infers wrong collation. #27146
• Fix the Common Table Expression (CTE) dead lock issue when used with IndexLookupJoin #27410
• Fix a bug that retryable deadlocks are incorrectly recorded into the INFORMATION_SCHEMA.DEADLOCKS table #27400
• Fix a bug that GROUP_CONCAT function does not consider the collation #27429
• Fix a bug that the COUNT(DISTINCT) function on multiple columns returns wrong results when New Collation is on #27091
• Fix an issue that the TABLESAMPLE query result from partitioned tables is not sorted as expected #27349
• Fix a bug that the EXTRACT function returns wrong results when the argument is a negative duration #27236
• Remove the unused /debug/sub-optimal-plan HTTP API #27265
• Fix the issue that a wrong selection is pushed down when the HAVING condition is used in the aggregate function #26496
• Fix a bug that the query may return wrong results when the hash partition table deals with unsigned data #26569
• Fix the unexpected behavior when casting an invalid string to DATE #26762
• Fix a bug that creating partition fails if NO_UNSIGNED_SUBTRACTION is set #26765
• Fix the issue that the distinct flag is missing when Apply is converted to Join #26958
• Fix the issue that NO_ZERO_IN_DATE does not work on the default values #26766
• Set a block duration for the newly recovered TiFlash node to avoid blocking queries during this time #26897
• Fix a bug that might occur when the CTE is referenced more than once #26212
• Fix a CTE bug when MergeJoin is used #25474
• Fix a bug that the 'SELECT FOR UPDATE' statement does not correctly lock the data when a normal table joins a partition table #26251
• Fix the issue that the 'SELECT FOR UPDATE' statement returns an error when a normal table joins a partition table #26250
• Fix the issue that PointGet does not use the lite version of resolve lock #26562