pingcap/tidb v5.4.1

tidb-server v5.4.1

on GitHub

Improvements

• Support using the PointGet plan for queries that read the _tidb_rowid column #31543
• Add more logs and metrics for the Apply operator to show whether it is parallel #33887
• Improve the TopN pruning logic for Analyze Version 2 used for collecting statistics #34256
• Support displaying multiple Kubernetes clusters in the Grafana dashboard #32593

Bug Fixes

• Fix the issue that date_format in TiDB handles '\n' in a MySQL-incompatible way #32232
• Fix the issue that TiDB writes wrong data due to the wrong encoding of the ENUM or SET column #32302
• Fix the issue that the Merge Join operator gets wrong results in certain cases #33042
• Fix the issue that TiDB gets a wrong result when a correlated subquery returns a constant #32089
• Fix the issue that TiDB gets the wrong result when using TiFlash to scan tables with empty range although TiFlash does not support reading tables with empty range yet #33083
• Fix the issue that the MAX or MIN function on the ENUM or SET column returns a wrong result when the new collation is enabled in TiDB #31638
• Fix a bug that CTE might be blocked when a query reports errors #31302
• Fix wrong range calculation results for Nulleq function on Enum values #32428
• Fix TiDB OOM when exporting data using ChunkRPC #31981 #30880
• Fix a bug that tidb_super_read_only is not automatically enabled when tidb_restricted_read_only is enabled #31745
• Fix the issue that the greatest or least function with collation gets a wrong result #31789
• Fix load data panic if the data is broken at an escape character #31589
• Fix the invalid transaction error when executing a query using index lookup join #30468
• Fix wrong results of deleting data of multiple tables using left join #31321
• Fix a bug that TiDB may dispatch duplicate tasks to TiFlash #32814
• Fix the issue that granting the all privilege might fail in clusters that are upgraded from v4.0 #33588
• Fix the session panic that occurs when executing the prepared statement after table schema change with the MySQL binary protocol #33509
• Fix the issue that executing SQL statements that have the compress() expression with tidb_enable_vectorized_expression enabled will fail #33397
• Fix the issue of high CPU usage by the reArrangeFallback function #30353
• Fix the issue that the table attributes are not indexed when a new partition is added and the issue that the table range information is not updated when the partition changes #33929
• Fix a bug that the TopN statistical information of a table during the initialization is not correctly sorted #34216
• Fix the error that occurs when reading from the INFORMATION_SCHEMA.ATTRIBUTES table by skipping the unidentifiable table attributes #33665
• Fix a bug that even if @@tidb_enable_parallel_apply is set, the Apply operator is not paralleled when an order property exists #34237
• Fix a bug that '0000-00-00 00:00:00' can be inserted into a datetime column when sql_mode is set to NO_ZERO_DATE #34099
• Fix the issue that the TiDB server might run out of memory when the INFORMATION_SCHEMA.CLUSTER_SLOW_QUERY table is queried. This issue can be triggered when you check slow queries on the Grafana dashboard. #33893
• Fix a bug that in the NOWAIT statement, a transaction being executed does not return immediately when encountering a lock #32754
• Fix a bug that causes a failure when creating a table with the GBK charset and gbk_bin collation #31308
• Fix a bug that when enable-new-charset is on, creating a GBK charset table with collation fails with the "Unknown character set" error #31297