TiDB 3.0.20 Release Notes

Release date: December 25, 2020

TiDB version: 3.0.20

Compatibility Change

• TiDB

  • Deprecate the enable-streaming configuration item #21054

Improvements

• TiDB

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

• TiKV

  • Add the end_point_slow_log_threshold configuration item #9145

Bug Fixes

• TiDB

  • Fix the incorrect cache of the transaction status 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

• TiKV

  • Fix the issue that an error is returned indicating that a key exists when this key is locked and deleted in a committed transaction #8931

• PD

  • Fix the issue that too many logs are printed when starting PD and when there are too many stale Regions #3064