TiDB 2.1.10 Release Notes

Release date: May 22, 2019

TiDB version: 2.1.10

TiDB Ansible version: 2.1.10

TiDB

  • Fix the issue that some abnormalities cause incorrect table schema when using tidb_snapshot to read the history data #10359
  • Fix the issue that the NOT function causes wrong read results in some cases #10363
  • Fix the wrong behavior of Generated Column in the Replace or Insert on duplicate update statement #10385
  • Fix a bug of the BETWEEN function in the DATE/DATETIME comparison #10407
  • Fix the issue that a single line of a slow log that is too long causes an error report when using the SLOW_QUERY table to query a slow log #10412
  • Fix the issue that the result of DATETIME plus INTERVAL is not the same with that of MySQL in some cases #10416, #10418
  • Add the check for the invalid time of February in a leap year #10417
  • Execute the internal initialization operation limitation only in the DDL owner to avoid a large number of conflict error reports when initializing the cluster #10426
  • Fix the issue that DESC is incompatible with MySQL when the default value of the output timestamp column is default current_timestamp on update current_timestamp #10337
  • Fix the issue that an error occurs during the privilege check in the Update statement #10439
  • Fix the issue that wrong calculation of RANGE causes a wrong result in the CHAR column in some cases #10455
  • Fix the issue that the data might be overwritten after decreasing SHARD_ROW_ID_BITS #9868
  • Fix the issue that ORDER BY RAND() does not return random numbers #10064
  • Prohibit the ALTER statement modifying the precision of decimals #10458
  • Fix the compatibility issue of the TIME_FORMAT function with MySQL #10474
  • Check the parameter validity of PERIOD_ADD #10430
  • Fix the issue that the behavior of the invalid YEAR string in TiDB is incompatible with that in MySQL #10493
  • Support the ALTER DATABASE syntax #10503
  • Fix the issue that the SLOW_QUERY memory engine reports an error when no ; exists in the slow query statement #10536
  • Fix the issue that the Add index operation in partitioned tables cannot be canceled in some cases #10533
  • Fix the issue that the OOM panic cannot be recovered in some cases #10545
  • Improve the security of the DDL operation rewriting the table metadata #10547

PD

  • Fix the issue that the priority of the leader does not take effect #1533

TiKV

  • Reject transferring the leader in a Region whose configuration has been changed recently to avoid transfer failure #4684
  • Add the priority label for Coprocessor metrics #4643
  • Fix the possible dirty read issue during transferring the leader #4724
  • Fix the issue that CommitMerge causes the restart failure of TiKV in some cases #4615
  • Fix unknown logs #4730

Tools

  • TiDB Lightning
    • Add the retry feature when TiDB Lightning fails to send data to importer #176
  • TiDB Binlog
    • Optimize the Pump storage log to facilitate troubleshooting #607

TiDB Ansible

  • Update the configuration file of TiDB Lightning and add the tidb_lightning_ctl script #d3a4a368