pingcap/tidb v4.0.12

tidb-server v4.0.12

on GitHub

Improvements

• Refine the output information of the EXPLAIN statement for the batch cop mode #23164
• Add the warning information for expressions that cannot be pushed to the storage layer in the output of the EXPLAIN statement #23020
• Migrate a part of the DDL package code from Execute/ExecRestricted to the safe API (2) #22935
• Migrate a part of the DDL package code from Execute/ExecRestricted to the safe API (1) #22929
• Add optimization-time and wait-TS-time into the slow log #22918
• Support querying partition_id from the infoschema.partitions table #22489
• Add last_plan_from_binding to help the users know whether a SQL statement's execution plan is matched with the hints in the binding #21430
• Scatter truncated tables without the pre-split option #22872
• Add three format specifiers for the str_to_date expression #22812
• Record the PREPARE execution failure as Failed Query OPM in the metrics monitor #22672
• Do not report errors for the PREPARE execution if tidb_snapshot is set #22641

Bug Fixes

• Fix the issue that the get variable expression goes wrong when the session variable is hexadecimal literals#23372
• Fix the issue that wrong collation is used when creating the fast execution plan for the Enum or Set type #23292
• Fix the possible wrong result of the nullif expression when it is used with is-null #23279
• Fix the issue that the auto-analysis is triggered outside its time range #23219
• Fix the issue that the CAST function might ignore errors for the point get plan #23211
• Fix a bug that prevents SPM from taking effect when CurrentDB is empty #23209
• Fix the issue of possible wrong table filters for the IndexMerge plan #23165
• Fix the issue of unexpected NotNullFlag in the returning types of the NULL constant #23135
• Fix a bug that collation might not be handled by the text type #23092
• Fix the issue that the range partition might incorrectly handle the IN expression #23074
• Fix the issue that after marking a TiKV store as tombstone, starting new TiKV stores with different StoreIDs with the same IP address and port keeps returning the StoreNotMatch error #23071
• Do not adjust the INT type when it is NULL and compared with YEAR #22844
• Fix the issue of lost connection when loading data on tables with the auto_random column #22736
• Fix the issue of DDL hangover when the DDL operation meets panic in the cancelling path #23297
• Fix the wrong key range of index scan when comparing the YEAR column with NULL #23104
• Fix the issue that a successfully created view is failed to use #23083