pingcap/tidb v4.0.6

tidb-server v4.0.6

on GitHub

Improvements

• Replace error codes and messages with standard errors #19888
• Improve the write performance of partitioned table #19649
• Record more RPC runtime information in Cop Runtime statistics #19264
• Forbid creating tables in metrics_schema and performance_schema #19792
• Support adjusting the concurrency of the union executor #19886
• Support out join in broadcast join #19664
• Add SQL digest for the process list #19829
• Switch to the pessimistic transaction mode for autocommit statement retry #19796
• Support the %r and %T data format in Str_to_date() #19693
• Enable SELECT INTO OUTFILE to require the file privilege #19577
• Support the stddev_pop function #19541
• Add the TiDB-Runtime dashboard #19396
• Improve compatibility for the ALTER TABLE algorithms #19364
• Encode insert/delete/update plans in the slow log plan field #19269

Bug Fixes

• Fix an issue of tikv_cop_wait time in metric profile #19881
• Fix the wrong result of SHOW GRANTS #19834
• Fix the incorrect query result of != ALL (subq) #19831
• Fix a bug of converting the enum and set types #19778
• Add a privilege check for SHOW STATS_META and SHOW STATS_BUCKET #19760
• Fix the error of unmatched column lengths caused by builtinGreatestStringSig and builtinLeastStringSig #19758
• If unnecessary errors or warnings occur, the vectorized control expresions fall back to their scalar execution #19749
• Fix an error of the Apply executor when the type of the correlation column is Bit #19692
• Fix an issue that occurs when the user queries processlist and cluster_log in MySQL 8.0 client #19690
• Fix an issue that plans of the same type have different plan digests #19684
• Forbid changing the column type from Decimal to Int #19682
• Fix an issue that SELECT ... INTO OUTFILE returns the runtime error #19672
• Fix an incorrect implementation of builtinRealIsFalseSig #19670
• Fix an issue that the partition expression check misses the parentheses expression #19614
• Fix a query error when there is an Apply executor upon HashJoin #19611
• Fix an incorrect result of vectorization that casts Real as Time #19594
• Fix a bug that the SHOW GRANTS statement shows grants for non-existent users #19588
• Fix a query error when there is an Apply executor upon IndexLookupJoin #19566
• Fix the wrong results when converting Apply to HashJoin on a partitioned table #19546
• Fix incorrect results when there is an IndexLookUp executor under the inner side of an Apply #19508
• Fix an unexpected panic when using view #19491
• Fix an incorrect result of anti-semi-join query #19477
• Fix a bug that topN statistics is not deleted when the statistics is dropped #19465
• Fix a wrong result caused by mistaken usage of batch point get #19460
• Fix a bug that a column cannot be found in indexLookupJoin with a virtual generated column #19439
• Fix an error that different plans of the select and update queries compare datum #19403
• Fix a data race for TiFlash work index in region cache #19362
• Fix a bug that the logarithm function does not show a warning #19291
• Fix an unexpected error that occurs when TiDB persists data to disk #19272
• Support using a single partitioned table on the inner side of index join #19197
• Fix the wrong hash key value generated for decimal #19188
• Fix an issue that TiDB returns an no regions error when table endKey and region endKey are the same #19895
• Fix the unexpected success of alter partition #19891
• Fix the wrong value of the default maximum packet length allowed for pushed down expressions #19876
• Fix a wrong behavior for the Max/Min functions on the ENUM/SET columns #19869
• Fix read failure from the tiflash_segments and tiflash_tables system tables when some TiFlash nodes are offline #19748
• Fix a wrong result of the Count(col) aggregation function #19628
• Fix a runtime error of the TRUNCATE operation #19445
• Fix the issue that PREPARE statement FROM @Var will fail when Var contains uppercase characters #19378
• Fix a bug that schema charset modification in an uppercase schema will cause panic #19302
• Fix inconsistency of plans between information_schema.statements_summary and explain, when the information contains tikv/tiflash #19159
• Fix the error in tests that the file does not exist for select into outfile #19725
• Fix the issue that INFORMATION_SCHEMA.CLUSTER_HARDWARE does not have raid device information #19457
• Make the add index operation that has a generated column with the case-when expression can exit normally when it encounters a parse error #19395
• Fix a bug that DDL takes too long to retry #19488
• Make statements like alter table db.t1 add constraint fk foreign key (c2) references t2(c1) execute without first executing use db #19471
• Change the dispatch error from an Error to an Info message in the server log file #19454