pingcap/tidb v4.0.11

tidb-server v4.0.11

on GitHub

New Features

• Support the utf8_unicode_ci and utf8mb4_unicode_ci collations #22558

Improvements

• Reorder inner joins that are simplified from outer joins #22402
• Support multiple clusters in Grafana dashboards #22534
• Add a workaround for the issue of multiple statements #22468
• Divide the metrics of slow query into internal and general #22405
• Add interface for utf8_unicode_ci and utf8mb4_unicode_ci collations #22099

Bug Fixes

• Fix the issue of abnormal unicode_ci constant propagation #22614
• Fix the issue that might causes wrong collation and coercibility #22602
• Fix the issue that might cause wrong collation results #22599
• Fix the issue of constant substitution for different collations #22582
• Fix a bug that the like function might return wrong result when using collation #22531
• Fix the issue of incorrect duration type inference in least and greatest functions #22580
• Fix a bug that occurs when the like function handles a single character wildcard (_) followed by a multiple character wildcard (%) #22575
• Fix the error of type inference when comparing TiDB's built-in functions (least and greatest) #22562
• Fix a bug that makes the like function get the wrong result if the pattern string is a unicode string #22529
• Fix a bug that the point get query does not get the snapshot data when the @@tidb_snapshot variable is set #22527
• Fix the potential panic that occurs when generating hints from joins #22518
• Fix the issue that strings are incorrectly converted to the BIT type #22420
• Fix the index out of range error that occurs when inserting values to the tidb_rowid column #22359
• Fix a bug that the cached plan is incorrectly used #22353
• Fix the runtime panic in the WEIGHT_STRING function when the length of the binary/char string is too large #22332
• Fix the issue that the generated column is incorrectly used when argument numbers are invalid #22174
• Correctly set the process information before building the execution plan #22148
• Fix the issue of inaccurate runtime statistics of IndexLookUp #22136
• Add cache for the memory usage information when the cluster is deployed in a container #22116
• Fix the issue that the execution plan is incorrectly decoded #22022
• Report errors for using invalid window specifications #21976
• Throw errors when the PREPARE statement is nested with EXECUTE, DEALLOCATE or PREPARE #21972
• Fix the issue that no error is reported when the INSERT IGNORE statement is used on a non-existing partition #21971
• Unify the encoding of EXPLAIN results and slow log #21964
• Fix the issue of unknown column in join when using the aggregate operator #21957
• Fix the wrong type inference in the ceiling function #21936
• Fix the issue that the Double type column ignores its decimal #21916
• Fix the issue that the correlated aggregation is calculated in subqueries #21877
• Report errors for the JSON object with key length >= 65536 #21870
• Fix the issue that the dyname function is incompatible with MySQL #21850
• Fix the issue that the to_base64 function returns NULL when the input data is too long #21813
• Fix the failure of comparing multiple fields in the subquery #21808
• Fix the issue that occurs when comparing the float type in JSON #21785
• Fix the issue that occurs when comparing the types of JSON objects #21718
• Fix the issue that the coercibility value of the cast function is incorrectly set #21714
• Fix an unexpected panic when using the IF function #21711
• Fix the issue that the NULL result returned from JSON search is incompatible with MySQL #21700
• Fix the issue that occurs when checking the only_full_group_by mode using ORDER BY and HAVING #21697
• Fix the issue that the units of Day and Time are incompatible with MySQL #21676
• Fix the issue that LEAD and LAG's default value cannot adapt to the field type #21665
• Perform a check to ensure that the LOAD DATA statement can only load data into base tables #21638
• Fix the issue that occurs when addtime and subtime functions handle invalid arguments #21635
• Change the round rule for approximate values to "round to the nearest even number" #21628
• Fix the issue that WEEK() does not recognize @@GLOBAL.default_week_format until it has been explicitly read #21623