Not found column generated_column_xxx in block when remote read is triggered #9561
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
CREATE TABLE `t` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '?',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '?',
KEY `idx_basic_lower_name` ((lower(`name`)))
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin AUTO_INCREMENT = 32409068
/*T! SHARD_ROW_ID_BITS=4 */
COMMENT = '?';
alter table t set tiflash replica 1;
insert into t (name)values("201801");
insert into t (name)values("201801");
insert into t (name)values("xxxxx");
insert into t (select * from t);
...
select a generated columnexplain analyze SELECT * FROM t a WHERE lower(a.name) like '%201801%'; and triggere remote read.
2. What did you expect to see? (Required)
no error
3. What did you see instead (Required)
get error: Not found column generated_column_xxx in block
4. What is your TiFlash version? (Required)
nightly: 02784a4
Metadata
Metadata
Assignees
Labels
This bug affects the 6.1.x(LTS) versions.This bug affects the 6.5.x(LTS) versions.This bug affects the 7.1.x(LTS) versions.This bug affects the 7.5.x(LTS) versions.This bug affects the 8.1.x(LTS) versions.This bug affects the 8.5.x(LTS) versions.Customers have encountered this bug.The issue is confirmed as a bug.