Sign InTry Free

TiDB 2.0.5 Release Notes

On July 6, 2018, TiDB 2.0.5 is released. Compared with TiDB 2.0.4, this release has great improvement in system compatibility and stability.


  • New Features
    • Add the tidb_disable_txn_auto_retry system variable which is used to disable the automatic retry of transactions #6877
  • Improvements
    • Optimize the cost calculation of Selection to make the result more accurate #6989
    • Select the query condition that completely matches the unique index or the primary key as the query path directly #6966
    • Execute necessary cleanup when failing to start the service #6964
    • Handle \N as NULL in the Load Data statement #6962
    • Optimize the code structure of CBO #6953
    • Report the monitoring metrics earlier when starting the service #6931
    • Optimize the format of slow queries by removing the line breaks in SQL statements and adding user information #6920
    • Support multiple asterisks in comments #6858
  • Bug Fixes
    • Fix the issue that KILL QUERY always requires SUPER privilege #7003
    • Fix the issue that users might fail to login when the number of users exceeds 1024 #6986
    • Fix an issue about inserting unsigned float/double data #6940
    • Fix the compatibility of the COM_FIELD_LIST command to resolve the panic issue in some MariaDB clients #6929
    • Fix the CREATE TABLE IF NOT EXISTS LIKE behavior #6928
    • Fix an issue in the process of TopN pushdown #6923
    • Fix the ID record issue of the currently processing row when an error occurs in executing Add Index #6903


  • Fix the issue that replicas migration uses up TiKV disks space in some scenarios
  • Fix the crash issue caused by AdjacentRegionScheduler


  • Fix the potential overflow issue in decimal operations
  • Fix the dirty read issue that might occur in the process of merging
Download PDFRequest docs changesAsk questions on TiDB ForumEdit this page
Was this page helpful?
TiDB Cloud
Get Demo
© 2023 PingCAP. All Rights Reserved.