TiDB - v5.1.5

Bug fixes

• Fix the issue that the window function causes TiDB to panic instead of reporting an error #30326
• Fix the wrong result that occurs when enabling dynamic mode in partitioned tables for TiFlash #37254
• Fix wrong results of GREATEST and LEAST when passing in unsigned BIGINT arguments #30101
• Fix wrong results of deleting data of multiple tables using left join #31321
• Fix the issue that the result of concat(ifnull(time(3))) in TiDB is different from that in MySQL #29498
• Fix the issue that the SQL statements that contain cast(integer as char) union string return wrong results #29513
• Fix the issue that INL_HASH_JOIN might hang when used with LIMIT #35638
• Fix the wrong ANY_VALUE result that occurs when a Region returns empty data #30923
• Fix wrong results of index join caused by an innerWorker panic #31494
• Fix the issue that a SQL operation is canceled when its JSON type column joins its CHAR type column #29401
• Fix the issue that the background HTTP service of TiDB might not exit successfully and makes the cluster in an abnormal state #30571
• Fix the issue that concurrent column type change causes inconsistency between the schema and the data #31048
• Fix the issue that KILL TIDB cannot take effect immediately on idle connections #24031
• Fix the bug that setting any session variable will make tidb_snapshot fail to work #35515
• Fix the issue that the Region cache is not cleaned up in time when the Region is merged #37141
• Fix the panic issue caused by the connection array race in the KV client #33773
• Fix the issue that when TiDB Binlog is enabled, executing the ALTER SEQUENCE statement might cause a wrong metadata version and cause Drainer to exit #36276
• Fix the bug that TiDB may panic when querying statement summary tables #35340
• 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 avg() function returns ERROR 1105 (HY000): other error for mpp stream: Could not convert to the target type - -value is out of range. when queried from TiFlash #29952
• Fix the issue that ERROR 1105 (HY000): close of nil channel is returned when using HashJoinExec #30289
• Fix the issue that TiKV and TiFlash return different results when querying logical operations #37258
• Fix the issue that the EXECUTE statement might throw an unexpected error in specific scenarios #37187
• Fix the planner wrong behaviors that occur when tidb_opt_agg_push_down and tidb_enforce_mpp are enabled #34465
• Fix a bug that TiDB might send coprocessor requests when executing the SHOW COLUMNS statement #36496
• Add warnings for lock tables and unlock tables when the enable-table-lock flag is not enabled #28967
• Fix the issue that range partitions allow multiple MAXVALUE partitions #36329