« Changelog History


tidb v2.1.3 Release Notes

Release Date: 2019-01-25 // over 5 years ago

  • ⚡️ SQL Optimizer/Executor

    • 🛠 Fix the panic issue of Prepared Plan Cache in some cases #8826
    • 🛠 Fix the issue that Range computing is wrong when the index is a prefix index #8851
    • 👉 Make CAST(str AS TIME(N)) return null if the string is in the illegal TIME format when SQL_MODE is not strict #8966
    • 🛠 Fix the panic issue of Generated Column during the process of UPDATE in some cases #8980
    • 🛠 Fix the upper bound overflow issue of the statistics histogram in some cases #8989
    • Support Range for _tidb_rowid construction queries, to avoid full table scan and reduce cluster stress #9059
    • Return an error when the CAST(AS TIME) precision is too big #9058
    • 👍 Allow using Sort Merge Join in the Cartesian product #9037
    • 🛠 Fix the issue that the statistics worker cannot resume after the panic in some cases #9085
    • 🛠 Fix the issue that Sort Merge Join returns the wrong result in some cases #9046
    • 👌 Support returning the JSON type in the CASE clause #8355 ### Server
    • ⚠ Return a warning instead of an error when the non-TiDB hint exists in the comment #8766
    • 👌 Verify the validity of the configured TIMEZONE value #8879
    • ⚡️ Optimize the QueryDurationHistogram metrics item to display more statement types #8875
    • 🛠 Fix the lower bound overflow issue of bigint in some cases #8544
    • Support the ALLOW_INVALID_DATES SQL mode #9110 ### DDL
    • 🛠 Fix a RENAME TABLE compatibility issue to keep the behavior consistent with that of MySQL #8808
    • 👌 Support making concurrent changes of ADD INDEX take effect immediately #8786
    • 🛠 Fix the UPDATE panic issue during the process of ADD COLUMN in some cases #8906
    • 🛠 Fix the issue of concurrently creating Table Partition in some cases #8902
    • 👌 Support converting the utf8 character set to utf8mb4 #8951 #9152
    • 🛠 Fix the issue of Shard Bits overflow #8976
    • 👌 Support outputting the column character sets in SHOW CREATE TABLE #9053
    • 🛠 Fix the issue of the maximum length limit of the varchar type column in utf8mb4 #8818
    • 👌 Support ALTER TABLE TRUNCATE TABLE PARTITION #9093
    • Resolve the charset when the charset is not provided #9147