tidb v4.0.6 Release Notes

Release Date: 2020-09-15 // over 3 years ago
  • ๐Ÿ‘Œ 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