Disaggrate TiFlash query result is wrong when query missing columns with default value #9085
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
use test;
CREATE TABLE `relationships` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id2` int(11) NOT NULL,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=90001;
insert into relationships (id2) values (1), (2), (3);
insert into relationships (id2) select id2 from relationships;
insert into relationships (id2) select id2 from relationships;
insert into relationships (id2) select id2 from relationships;
insert into relationships (id2) select id2 from relationships;
insert into relationships (id2) select id2 from relationships;
insert into relationships (id2) select id2 from relationships;
alter table relationships set tiflash replica 1;
alter table relationships add column weight int default '0';
select * from information_schema.tiflash_replica where TABLE_NAME = 'relationships';
set @@tidb_isolation_read_engines='tiflash'; select count(*) from relationships where weight = 0;
2. What did you expect to see? (Required)
set @@tidb_isolation_read_engines='tiflash'; select count(*) from relationships where weight = 0;
+----------+
| count(*) |
+----------+
| 192 |
+----------+
3. What did you see instead (Required)
set @@tidb_isolation_read_engines='tiflash'; select count(*) from relationships where weight = 0;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
4. What is your TiFlash version? (Required)
master