All Versions
64
Latest Version
Avg Release Cycle
28 days
Latest Release
1273 days ago

Changelog History
Page 5

  • v2.1.11 Changes

    May 31, 2019
    • 🛠 Fix the issue that incorrect schema is used for delete from join #10595
    • 🛠 Fix the issue that the built-in CONVERT() may return incorrect field type #10263
    • ⚡️ Merge non-overlapped feedback when updating bucket count #10569
    • Fix calculation errors of unix_timestamp()-unix_timestamp(now()) #10491
    • 🛠 Fix the incompatibility issue of period_diff with MySQL 8.0 #10501
    • Skip Virtual Column when collecting statistics to avoid exceptions #10628
    • 👌 Support the SHOW OPEN TABLES statement #10374
    • 🛠 Fix the issue that goroutine leak may happen in some cases #10656
    • 🛠 Fix the issue that setting the tidb_snapshot variable in some cases may cause incorrect parsing of time format #10637

  • v2.1.10 Changes

    May 21, 2019
    • 🛠 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

  • v2.1.9 Changes

    May 06, 2019
    • 🛠 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

  • v2.1.8 Changes

    April 12, 2019
    • 🛠 Fix the issue that the processing logic of GROUP_CONCAT function is incompatible with MySQL when there is a NULL-valued parameter #9930
    • 🛠 Fix the equality check issue of decimal values in the Distinct mode #9931
    • 🛠 Fix the collation compatibility issue of the date, datetime, and timestamp types for the SHOW FULL COLUMNS statement
    • 🛠 Fix the issue that the row count estimation is inaccurate when the filtering condition contains correlated columns #9937
    • ➕ Fix the compatibility issue between the DATE_ADD and DATE_SUB functions
    • Support the %H format for the STR_TO_DATE function to improve compatibility #9964
    • 🛠 Fix the issue that the result is wrong when the GROUP_CONCAT function groups by a unique index #9969
    • ⚡️ Return a warning when the Optimizer Hints contains an unmatched table name #9970
    • 🔊 Unify the log format to facilitate collecting logs using tools for analysis Unified Log Format
    • 🛠 Fix the issue that a lot of NULL values cause inaccurate statistics estimation #9979
    • 🛠 Fix the issue that an error is reported when the default value of the TIMESTAMP type is the boundary value #9987
    • Validate the value of time_zone #10000
    • 👌 Support the 2019.01.01 time format #10001
    • 🛠 Fix the issue that the row count estimation is displayed incorrectly in the result returned by the EXPLAIN statement in some cases #10044
    • 🛠 Fix the issue that KILL TIDB [session id] cannot instantly stop the execution of a statement in some cases #9976
    • 🛠 Fix the predicate pushdown issue of constant filtering conditions in some cases #10049
    • 🛠 Fix the issue that a read-only statement is not processed correctly in some cases #10048

  • v2.1.7 Changes

    March 27, 2019
    • 🛠 Fix the issue of longer startup time when upgrading the program caused by canceling DDL operations #9768
    • 🛠 Fix the issue that the check-mb4-value-in-utf8 configuration item is in the wrong position in the config.example.toml file #9852
    • Improve the compatibility of the str_to_date built-in function with MySQL #9817
    • 🛠 Fix the compatibility issue of the last_day built-in function #9750
    • Add the tidb_table_id column for infoschema.tables to facilitate getting table_id by using SQL statements and add the tidb_indexes system table to manage the relationship between Table and Index #9862
    • ➕ Add a check about the null definition of Table Partition #9663
    • 🔄 Change the privileges required by Truncate Table from Delete to Drop to make it consistent with MySQL #9876
    • 👌 Support using subqueries in the DO statement #9877
    • Fix the issue that the default_week_format variable does not take effect in the week function #9753
    • 👌 Support the plugin framework #9880, #9888
    • 👌 Support checking the enabling state of binlog by using the log_bin system variable #9634
    • 👌 Support checking the Pump/Drainer status by using SQL statements #9896
    • 🛠 Fix the compatibility issue about checking mb4 character on utf8 when upgrading TiDB #9887

  • v2.1.6 Changes

    March 15, 2019

    ⚡️ SQL Optimizer/Executor

    • ⚡️ Optimize planner to select the outer table based on cost when both tables are specified in Hint of TIDB_INLJ #9615
    • 🛠 Fix the issue that IndexScan cannot be selected correctly in some cases #9587
    • 🛠 Fix incompatibility with MySQL of check in the agg function in subqueries #9551
    • 👉 Make show stats_histograms only output valid columns to avoid panics #9502 ### Server
    • 👌 Support the log_bin variable to enable/disable Binlog #9634
    • ➕ Add a sanity check for transactions to avoid false transaction commit #9559
    • 🛠 Fix the issue that setting variables may lead to panic #9539

    DDL

    • 🛠 Fix the issue that the Create Table Like statement causes panic in some cases #9652
    • Enable the AutoSync feature of etcd clients to avoid connection issues between TiDB and etcd in some cases #9600

  • v2.1.5 Changes

    February 28, 2019

    ⚡️ 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

  • v2.1.4 Changes

    February 15, 2019

    ⚡️ SQL Optimizer/Executor

    • 🛠 Fix the issue that the VALUES function does not handle the FLOAT type correctly #9223
    • 🛠 Fix the wrong result issue when casting Float to String in some cases #9227
    • 🛠 Fix the wrong result issue of the FORMAT function in some cases #9235
    • 🛠 Fix the panic issue when handling the Join query in some cases #9264
    • 🛠 Fix the issue that the VALUES function does not handle the ENUM type correctly #9280
    • ➕ Fix the wrong result issue of DATE_ADD / DATE_SUB in some cases #9284

    Server

    • ⚡️ Optimize the "reload privilege success" log and change it to the DEBUG level #9274

    DDL

    • Change tidb_ddl_reorg_worker_cnt and tidb_ddl_reorg_batch_size to global variables #9134
    • 🛠 Fix the bug caused by adding an index to a generated column in some abnormal conditions #9289

  • v2.1.3 Changes

    January 25, 2019

    ⚡️ 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

  • v2.1.2 Changes

    December 21, 2018
    • 👉 Make TiDB compatible with TiDB-Binlog of the Kafka version #8747
    • 👌 Improve the exit mechanism of TiDB in a rolling update #8707
    • 🛠 Fix the panic issue caused by adding the index for the generated column in some cases #8676
    • 🛠 Fix the issue that the optimizer cannot find the optimal query plan when TIDB_SMJ Hint exists in the SQL statement in some cases #8729
    • 🛠 Fix the issue that AntiSemiJoin returns an incorrect result in some cases #8730
    • 👌 Improve the valid character check of the utf8 character set #8754
    • 🛠 Fix the issue that the field of the time type might return an incorrect result when the write operation is performed before the read operation in a transaction #8746