« Changelog History


tidb v2.1.5 Release Notes

Release Date: 2019-02-28 // about 5 years ago

  • ⚡️ SQL Optimizer/Executor

    • 🖨 Make SHOW CREATE TABLE do not print the column charset information when the charset information of a column is the same with that of a table, to improve the compatibility of SHOW CREATE TABLE with MySQL #9306
    • 🛠 Fix the panic or the wrong result of the Sort operator in some cases by extracting ScalarFunc from Sort to a Projection operator for computing to simplify the computing logic of Sort #9319
    • ✂ Remove the sorting field with constant values in the Sort operator #9335, #9440
    • 🛠 Fix the data overflow issue when inserting data into an unsigned integer column #9339
    • Set cast_as_binary to NULL when the length of the target binary exceeds max_allowed_packet #9349
    • ⚡️ Optimize the constant folding process of IF and IFNULL #9351
    • ⚡️ Optimize the index selection of TiDB using skyline pruning to improve the stability of simple queries #9356
    • 👌 Support computing the selectivity of the DNF expression #9405
    • 🛠 Fix the wrong SQL query result of !=ANY() and =ALL() in some cases #9403
    • 🛠 Fix the panic or the wrong result when the Join Key types of two tables on which the Merge Join operation is performed are different #9438
    • 🛠 Fix the issue that the result of the RAND() function is not compatible with MySQL #9446
    • 🔨 Refactor the logic of Semi Join processing NULL and the empty result set to get the correct result and improve the compatibility with MySQL #9449

    Server

    • Add the tidb_constraint_check_in_place system variable to check the data uniqueness constraint when executing the INSERT statement #9401
    • 👮 Fix the issue that the value of the tidb_force_priority system variable is different from that set in the configuration file #9347
    • ➕ Add the current_db field in general logs to print the name of the currently used database #9346
    • ➕ Add an HTTP API of obtaining the table information with the table ID #9408
    • 🛠 Fix the issue that LOAD DATA loads incorrect data in some cases #9414
    • 🛠 Fix the issue that it takes a long time to build a connection between the MySQL client and TiDB in some cases #9451

    DDL

    • 🛠 Fix some issues when canceling the DROP COLUMN operation #9352
    • 🛠 Fix some issues when canceling the DROP or ADD partitioned table operation #9376
    • 🛠 Fix the issue that ADMIN CHECK TABLE mistakenly reports the data index inconsistency in some cases #9399
    • 🛠 Fix the time zone issue of the TIMESTAMP default value #9108