TiDB 2.1.15 Release Notes

Release date: July 16, 2019

TiDB version: 2.1.15

TiDB Ansible version: 2.1.15

TiDB

• Fix the issue that the DATE_ADD function returns wrong results due to incorrect alignment when dealing with microseconds #11289
• Fix the issue that an error is reported when the empty value in the string column is compared with FLOAT or INT #11279
• Fix the issue that the INSERT function fails to correctly return the NULL value when a parameter is NULL #11249
• Fix the issue that an error occurs when indexing the column of the non-string type and 0 length #11215
• Add the SHOW TABLE REGIONS statement to query the Region distribution of a table through SQL statements #11238
• Fix the issue that an error is reported when using the UPDATE … SELECT statement because the projection elimination is used to optimize rules in the SELECT subqueries #11254
• Add the ADMIN PLUGINS ENABLE/ADMIN PLUGINS DISABLE SQL statement to dynamically enable or disable plugins #11189
• Add the session connection information in the Audit plugin #11189
• Fix the panic issue that happens when a column is queried on multiple times and the returned result is NULL during point queries #11227
• Add the tidb_scatter_region configuration item to scatter table Regions when creating a table #11213
• Fix the data race issue caused by non-thread safe rand.Rand when using the RAND function #11170
• Fix the issue that the comparison result of integers and non-integers is incorrect in some cases #11191
• Support modifying the collation of a database or a table, but the character set of the database/table has to be UTF-8 or utf8mb4 #11085
• Fix the issue that the precision shown by the SHOW CREATE TABLE statement is incomplete when CURRENT_TIMESTAMP is used as the default value of the column and the float precision is specified #11087

TiKV

• Unify the log format #5083
• Improve the accuracy of Region's approximate size or keys in extreme cases to improve the accuracy of scheduling #5085

PD

• Unify the log format #1625

Tools

TiDB Binlog

• Optimize the Pump GC strategy and remove the restriction that the unconsumed binlog cannot be cleaned to make sure that the resources are not occupied for a long time #663

TiDB Lightning

• Fix the import error that happens when the column names specified by the SQL dump are not in lowercase #210

TiDB Ansible

• Add the parse duration and compile duration monitoring items in TiDB Dashboard to monitor the time that it takes to parse SQL statements and execute compilation #815