pingcap/tidb v4.0.9

tidb-server v4.0.9

on GitHub

Compatibility Changes

• Deprecate the enable-streaming configuration item #21055

Improvements

• Avoid the (index) merge join in a heuristical way when converting equal conditions to other conditions #21146
• Differentiate the types of user variables #21107
• Support setting the GOGC variable in the configuration file #20922
• Make the dumped binary time (Timestamp and Datetime) more compatible with MySQL #21135
• Provide an error message for statements that use the LOCK IN SHARE MODE syntax #21005
• Avoid outputting unnecessary warnings or errors when folding constants in shortcut-able expressions #21040
• Raise an error when preparing the LOAD DATA statement #21199
• Ignore the attribute of the integer zero-fill size when changing the integer column types #20986
• Add the executor-related runtime information of DML statements in the result of EXPLAIN ANALYZE #21066
• Disallow multiple updates on the primary key in a singe SQL statements #21113
• Add a monitoring metric for the connection idle time #21301
• Temporarily enable the slow log when the runtime/trace tool is running #20578

Bug Fixes

• Fix the issue that incorrect result is returned for indeterministic function when executing a prepared point-get update with "prepared plan cache" is disabled #21883
• Fix the issue of incorrect results when using a prefix index with the OR condition #21287
• Fix a bug that might cause panic when automatic retry is enabled #21285
• Fix a bug that occurs when checking partition definition according to column type #21273
• Fix a bug that the value type of the partition expression is not consistent with the partition column type #21136
• Fix a bug that the hash-type partition does not check whether the partition name is unique #21257
• Fix the wrong results returned after inserting a value of the non-INT type into the hash partitioned table #21238
• Fix the unexpected error when using index join in the INSERT statement in some cases #21249
• Fix the issue that the BigInt unsigned column value in the CASE WHEN operator is incorrectly converted to the BigInt signed value #21236
• Fix a bug that index hash join and index merge join do not consider collation #21219
• Fix a bug that the partitioned table does not consider collation in the CREATE TABLE and SELECT syntax #21181
• Fix the issue that the query result of slow_query might miss some rows #21211
• Fix the issue that DELETE might not delete data correctly when the database name is not in a pure lower representation #21206
• Fix a bug that causes schema change after DML operations #21050
• Fix the bug that the coalesced column cannot be queried when using join #21021
• Fix the wrong results of some semi-join queries #21019
• Fix the issue that the table lock does not take effect on the UPDATE statement #21002
• Fix the issue of stack overflow that occurs when building the recursive view #21001
• Fix the unexpected result returned when performing index merge join operations on outer join #20954
• Fix the issue that sometimes a transaction that has an undetermined result might be treated as failed #20925
• Fix the issue that EXPLAIN FOR CONNECTION cannot show the last query plan #21315
• Fix the issue that when Index Merge is used in a transaction with the Read Committed isolation level, the result might be incorrect #21253
• Fix the auto-ID allocation failure caused by the transaction retry after the write conflict #21079
• Fix the issue that JSON data cannot be correctly imported to TiDB using LOAD DATA #21074
• Fix the issue that the default value of newly added Enum-type columns is incorrect #20998
• Fix the issue that the adddate function inserts invalid characters #21176
• Fix the issue that the wrong PointGet plan generated in some situations causes wrong results #21244
• Ignore the conversion of daylight saving time in the ADD_DATE function to be compatible with MySQL #20888
• Fix a bug that prevents inserting strings with trailing spaces that exceed varchar or char's length constraint #21282
• Fix a bug that does not converting the integer from [1, 69] to [2001, 2069] or from [70, 99] to [1970, 1999] when comparing int with year #21283
• Fix the panic caused by the overflowing result of the sum() function when calculating the Double type field #21272
• Fix a bug that DELETE fails to add lock on the unique key #20705
• Fix a bug that snapshot reads hits the lock cache #21539
• Fix an issue of potential memory leak after reading a lot of data in a long-lived transaction #21129
• Fix the issue that omitting the table alias in a subquery will have a syntax error returned #20367