| title |
TiDB 2.0.5 Release Notes |
| aliases |
/docs/dev/releases/release-2.0.5/ |
/docs/dev/releases/205/ |
|
| summary |
TiDB 2.0.5 was released on July 6, 2018, with improvements in system compatibility and stability. New features include the `tidb_disable_txn_auto_retry` system variable. Bug fixes address issues with user login, data insertion, and command compatibility. PD and TiKV also received fixes for various issues. |
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