tidb-server v4.0.11
New Features
- Support the
utf8_unicode_ci
andutf8mb4_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
andgeneral
#22405 - Add interface for
utf8_unicode_ci
andutf8mb4_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 inleast
andgreatest
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
andgreatest
) #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 thetidb_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 withEXECUTE
,DEALLOCATE
orPREPARE
#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 returnsNULL
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 usingORDER BY
andHAVING
#21697 - Fix the issue that the units of
Day
andTime
are incompatible with MySQL #21676 - Fix the issue that
LEAD
andLAG
'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
andsubtime
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