Skip to content

Query partition table failed after rename column #9787

@Lloyd-Pottiger

Description

@Lloyd-Pottiger

Bug Report

Ref: pingcap/tidb#58388

1. Minimal reproduce step (Required)

CREATE TABLE `t6f9b1fca` (
  `col5def` mediumint DEFAULT '1398811',
  `colb0ec` datetime DEFAULT '8060-08-20 09:18:05',
  `colc4d2` year(4) DEFAULT '2123',
  `colf318` enum('vzd','f1y','wndk','bdw9','qkg','pj','z3','6pj2q','zgm','x5qj','uiyv') DEFAULT 'bdw9',
  `3f60e6b3` decimal(33,25) DEFAULT '-66552329.3166265233570726682245357',
  `colf8a2` bigint DEFAULT '600923851820286643',
  `col9e6f` float DEFAULT '1.9193193',
  `col972e` mediumint DEFAULT '-74934',
  `col9328` varchar(109) DEFAULT 'hkq8osq',
  `col8e36` double DEFAULT '1.5676352034154104'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin /*T! SHARD_ROW_ID_BITS=1 */ COMMENT='27f3f141'
PARTITION BY HASH (`colf8a2`) PARTITIONS 9;

insert into t6f9b1fca values ();
alter table t6f9b1fca set tiflash replica 1;
select * from t6f9b1fca;

alter table t6f9b1fca change 3f60e6b3 3f60e6b2 decimal(33,25) DEFAULT '-66552329.3166265233570726682245357';
set tidb_enforce_mpp=1; select * from `t6f9b1fca`;
ERROR 1105 (HY000): other error for mpp stream: Code: 10, e.displayText() = DB::Exception: Not found column 3f60e6b3 in block. There are only columns: _tidb_rowid, _INTERNAL_VERSION, _INTERNAL_DELMARK, col5def, colb0ec, col7211, colc4d2, colf318, col7579, 3f60e6b2, colf8a2, col9e6f, col972e, col9328, col8e36: (while creating read sources from storage, keyspace_id=4294967295 table_id=119 logical_table_id=110), e.what() = DB::Exception,

2. What did you expect to see? (Required)

success

3. What did you see instead (Required)

failed

4. What is your TiFlash version? (Required)

master

Metadata

Metadata

Labels

affects-7.5This bug affects the 7.5.x(LTS) versions.affects-8.1This bug affects the 8.1.x(LTS) versions.affects-8.5This bug affects the 8.5.x(LTS) versions.component/storageseverity/majortype/bugThe issue is confirmed as a bug.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions