TiDB 6.1.6 Release Notes
Release date: April 12, 2023
TiDB version: 6.1.6
Quick access: Quick start | Production deployment
Compatibility changes
TiCDC fixes the issue of incorrect encoding of FLOAT data in Avro #8490 @3AceShowHand
When upgrading the TiCDC cluster to v6.1.6 or a later v6.1.x version, if a table replicated using Avro contains the
FLOAT
data type, you need to manually adjust the compatibility policy of Confluent Schema Registry toNone
before upgrading so that the changefeed can successfully update the schema. Otherwise, after upgrading, the changefeed will be unable to update the schema and enter an error state.
Improvements
TiDB
TiKV
- Support starting TiKV on a CPU with less than 1 core #13586 #13752 #14017 @andreid-db @andreid-db
Bug fixes
TiDB
- Fix the issue that the
ignore_plan_cache
hint might not work forINSERT
statements #40079 #39717 @qw4990 - Fix the issue that TiDB might panic after
indexMerge
encounters an error #41047 #40877 @guo-shaoge @windtalker - Fix the issue that incorrect results might be returned when TopN operators with virtual columns are mistakenly pushing down to TiKV or TiFlash #41355 @Dousir9
- Fix the PD OOM issue when there is a large number of Regions but the table ID cannot be pushed down when querying some virtual tables using
Prepare
orExecute
#39605 @djshow832 - Fix the issue that Plan Cache might cache FullScan plans when processing
int_col in (decimal...)
conditions #40224 @qw4990 - Fix the issue that IndexMerge plans might generate incorrect ranges on the SET type columns #41273 #41293 @time-and-fate
- Fix the issue of potential wrong results when comparing unsigned
TINYINT
/SMALLINT
/INT
values withDECIMAL
/FLOAT
/DOUBLE
values smaller than0
#41736 @LittleFall - 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 @crazycs520 - Fix the issue that range partitions allow multiple
MAXVALUE
partitions #36329 @u5surf - Fix the issue that Plan Cache might cache Shuffle operators and return incorrect results #38335 @qw4990
- Fix the issue that data race in time zone might cause data-index inconsistency #40710 @wjhuang2016
- Fix the issue that goroutine leak might occur in
indexMerge
#41545 #41605 @guo-shaoge @guo-shaoge - Fix the issue that, when using Cursor Fetch and running other statements among Execute, Fetch, and Close, the Fetch and Close commands might return incorrect results or cause TiDB to panic #40094 @YangKeao
- Fix the issue that when modifying the floating-point type using DDL to keep the length unchanged and reduce the decimal places, the old data still remains the same #41281 @zimulala
- Fix the issue that joining the
information_schema.columns
table causes TiDB to panic #32459 @tangenta - Fix the issue that TiDB panic occurs due to inconsistent InfoSchema being obtained when generating the execution plan #41622 @tiancaiamao
- Fix the issue that TiFlash reports an error for generated columns during execution #40663 @guo-shaoge
- Fix the issue that TiDB might produce incorrect results when different partitioned tables appear in a single SQL statement #42135 @mjonss
- Fix the issue that Plan Cache might cache Shuffle operators and return incorrect results #38335 @qw4990 @fzzf678
- Fix the issue that using Index Merge to read a table containing the
SET
type column might lead to incorrect results #41293 @time-and-fate - Fix the issue that full index scans might cause errors when prepared plan cache is enabled #42150 @fzzf678
- Fix the issue that SQL statements using
PointGet
to read a table during the execution of a DDL statement might throw a panic #41622 @tiancaiamao - Fix the issue that after executing
PointUpdate
within a transaction, TiDB returns incorrect results for theSELECT
statement #28011 @zyguan - Clear expired region cache regularly to avoid memory leak and performance degradation #40461 @sticnarf @zyguan
- Fix the issue that
INSERT IGNORE
andREPLACE
statements do not lock keys that do not modify values #42121 @zyguan
- Fix the issue that the
TiKV
- Fix an error that occurs when casting the
const Enum
type to other types #14156 @wshwsh12 - Fix the issue of CPU quota limitation #13084 @BornChanger
- Fix the issue of incorrect snapshot last index #12618 @LintianShi
- Fix an error that occurs when casting the
PD
TiFlash
- Fix the issue that semi-joins use excessive memory when calculating Cartesian products #6730 @gengliqi
- Fix the issue that TiFlash log search is too slow #6829 @hehechen
- Fix the issue that TopN/Sort operators produce incorrect results after enabling the new collation #6807 @xzhangxian1008
- Fix the issue that Decimal cast rounds up incorrectly in certain cases #6994 @windtalker
- Fix the issue that TiFlash cannot recognize generated columns #6801 @guo-shaoge
- Fix the issue that Decimal division does not round up the last digit in certain cases #7022 @LittleFall
Tools
TiCDC
- Fix the issue that the disorder of
UPDATE
andINSERT
statements during data replication might cause theDuplicate entry
error #8597 @sdojjy - Fix the abnormal exit issue of the TiCDC service caused by network isolation between PD and TiCDC #8562 @overvenus
- Fix the data inconsistency that occurs when replicating data to a TiDB or MySQL sink and when
CHARACTER SET
is specified on the column that has the non-null unique index without a primary key #8420 @zhaoxinyu - Fix the issue that the memory usage of
db sorter
is not controlled bycgroup memory limit
#8588 @amyangfei - Optimize the error message of
cdc cli
for invalid input #7903 @CharlesCheung96 - Fix the issue of insufficient duration that redo log can tolerate for S3 storage failure #8089 @CharlesCheung96
- Fix the issue that pausing a changefeed when PD is abnormal results in incorrect status #8330 @sdojjy
- Fix the issue that the disorder of
TiDB Lightning
- Fix the issue that the conflict resolution logic (
duplicate-resolution
) might lead to inconsistent checksums #40657 @sleepymole - Fix the issue that TiDB Lightning panics in the split-region phase #40934 @lance6716
- Fix the issue that when importing data in Local Backend mode, the target columns do not automatically generate data if the compound primary key of the imported target table has an
auto_random
column and no value for the column is specified in the source data #41454 @D3Hunter - Fix the issue that TiDB Lightning might incorrectly skip conflict resolution when all but the last TiDB Lightning instance encounters a local duplicate record during a parallel import #40923 @lichunzhu
- Fix the issue that the conflict resolution logic (