Releases
v5.1.2
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
You can’t perform that action at this time.