TiDB 2.1.9 Release Notes
Release date: May 6, 2019
TiDB version: 2.1.9
TiDB-Ansible version: 2.1.9
TiDB
- Fix compatibility of the
MAKETIME
function when unsigned type overflows #10089 - Fix the stack overflow caused by constant folding in some cases #10189
- Fix the privilege check issue for
Update
when an alias exists in some cases #10157, #10326 - Track and control memory usage in DistSQL #10197
- Support specifying collation as
utf8mb4_0900_ai_ci
#10201 - Fix the wrong result issue of the
MAX
function when the primary key is of the Unsigned type #10209 - Fix the issue that NULL values can be inserted into NOT NULL columns in the non-strict SQL mode #10254
- Fix the wrong result issue of the
COUNT
function when multiple columns exist inDISTINCT
#10270 - Fix the panic issue occurred when
LOAD DATA
parses irregular CSV files #10269 - Ignore the overflow error when the outer and inner join key types are inconsistent in
Index Lookup Join
#10244 - Fix the issue that a statement is wrongly judged as point-get in some cases #10299
- Fix the wrong result issue when the time type does not convert the time zone in some cases #10345
- Fix the issue that TiDB character set cases are inconsistent in some cases #10354
- Support controlling the number of rows returned by operator #9166
- Improve the slow query log
- Add
SQL Digest
to distinguish similar SQL #10093 - Add version information of statistics used by slow query statements #10220
- Show memory consumption of a statement in slow query log #10246
- Adjust the output format of Coprocessor related information so it can be parsed by pt-query-digest #10300
- Fix the
#
character issue in slow query statements #10275 - Add some information columns to the memory table of slow query statements #10317
- Add the transaction commit time to slow query log #10310
- Fix the issue some time formats cannot be parsed by pt-query-digest #10323
- Add
PD
- Support the GetOperator service #1514
TiKV
- Fix potential quorum changes when transferring leader #4604
Tools
- TiDB Binlog
- Fix the issue that data replication is interrupted because data in the unsigned int type of primary key column are minus numbers #574
- Remove the compression option when the downstream is
pb
and change the downstream name frompb
tofile
#597 - Fix the bug that Reparo introduced in 2.1.7 generates wrong
UPDATE
statements #576
- TiDB Lightning
- Fix the bug that the bit type of column data is incorrectly parsed by the parser #164
- Fill the lacking column data in dump files using row id or the default column value #174
- Fix the Importer bug that some SST files fail to be imported but it still returns successful import result #4566
- Support setting a speed limit in Importer when uploading SST files to TiKV #4607
- Change Importer RocksDB SST compression method to
lz4
to reduce CPU consumption #4624
- sync-diff-inspector
- Support checkpoint #227