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 in DISTINCT #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
  • Selection & Projection #10110
  • StreamAgg & HashAgg #10133
  • TableReader & IndexReader & IndexLookup #10169
• 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

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 from pb to file #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

TiDB Ansible

• Update links in tidb-ansible documentation according to docs refactoring #740, #741
• Remove the enable_slow_query_log parameter in the inventory.ini file and output the slow query log to a separate log file by default #742