Closed wjhuang2016 closed 1 month ago
Reproduction SQLs:
set tidb_partition_prune_mode=static;
CREATE TABLE `tad8c9f80` (
`col_37` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`col_38` float NOT NULL DEFAULT '3514.3777',
`col_39` datetime DEFAULT NULL,
`col_40` bit(12) NOT NULL,
`col_41` float NOT NULL,
`col_42` mediumint(8) unsigned NOT NULL DEFAULT '11075363',
`col_43` binary(171) DEFAULT 'v@O+MkoF6(zDD\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`col_44` tinyblob NOT NULL,
`col_45` varchar(174) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT 'ax&7',
PRIMARY KEY (`col_42`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
PARTITION BY KEY (`col_42`) PARTITIONS 7;
insert into tad8c9f80 values ('a',4.3,20240702,1,1.23,6970066,'0a','a','c');
explain update tad8c9f80 set tad8c9f80.col_44 = 'AH6' ,tad8c9f80.col_43 = 'O%uH' ,tad8c9f80.col_38 = 7194.863539582079 where tad8c9f80.col_42 in ( 7691699 ,11807884 ,10523838 ,15662349 ,6970066 );
The problem is caused by https://github.com/pingcap/tidb/pull/49161, the case is static prune + batchPointGet. /cc @mjonss
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
No panic
3. What did you see instead (Required)
Panic
4. What is your TiDB version? (Required)
master