title | aliases | summary | ||
---|---|---|---|---|
TiDB 2.1.15 Release Notes |
|
TiDB 2.1.15 was released on July 16, 2019. It includes various bug fixes and improvements, such as fixing issues with functions like DATE_ADD and INSERT, adding new SQL statements like SHOW TABLE REGIONS, and enhancing the Audit plugin. TiKV and PD also received updates to unify log formats and improve accuracy. Additionally, there were optimizations made to TiDB Binlog and TiDB Lightning, and new monitoring items added to TiDB Ansible. |
Release date: July 16, 2019
TiDB version: 2.1.15
TiDB Ansible version: 2.1.15
- 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
orINT
#11279 - Fix the issue that the
INSERT
function fails to correctly return theNULL
value when a parameter isNULL
#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 theSELECT
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 theRAND
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 whenCURRENT_TIMESTAMP
is used as the default value of the column and the float precision is specified #11087
- 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
- Unify the log format #1625
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
- Add the
parse duration
andcompile duration
monitoring items in TiDB Dashboard to monitor the time that it takes to parse SQL statements and execute compilation #815