pingcap/tidb v3.0.20

tidb-server v3.0.20

on GitHub

Compatibility Change

• Deprecate the enable-streaming configuration item #21054

Improvements

• Raise an error when preparing the LOAD DATA statement #21222

Bug Fixes

• Fix the resolved txn status cache for pessimistic transactions. #21706
• Fix the issue of inaccurate statistics that occurs when querying INFORMATION_SCHEMA.TIDB_HOT_REGIONS #21319
• Fix the issue that DELETE might not delete data correctly when the database name is not in a pure lower representation #21205
• Fix the issue of stack overflow that occurs when building the recursive view #21000
• Fix the issue of goroutine leak in TiKV client #20863
• Fix the wrong default zero value for the year type #20828
• Fix the issue of goroutine leak in index lookup join #20791
• Fix the issue that executing INSERT SELECT FOR UPDATE returns the malformed packet in the pessimistic transaction #20681
• Fix the unknown time zone 'posixrules' #20605
• Fix the issue that occurs when converting the unsigned integer type to the bit type #20362
• Fix the corrupted default value of the bit type column #20339
• Fix the potentially incorrect results when one of the equal condition is the Enum or Set type #20296
• Fix a wrong behavior of != any() #20061
• Fix the issue that type conversion in BETWEEN...AND... returns invalid results #21503
• Fix a compatibility issue with the ADDDATE function #21008
• Set the correct default value for newly added Enum column #20999
• Fix the result of SQL statements like SELECT DATE_ADD('2007-03-28 22:08:28',INTERVAL "-2.-2" SECOND) to be compatible with MySQL #20627
• Fix the incorrect default value when modifying the column type #20532
• Fix the issue that the timestamp function gets wrong result when the input argument is the float or decimal type #20469
• Fix a potential deadlock issue in statistics #20424
• Fix the issue that the overflown float type data is inserted #20251