TiDB return wrong result when select partition table from TiFlash

[lidezhu]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

run the following sql:
create table test.employees (id int,store_id int not null)partition by hash(store_id) partitions 4;
alter table test.employees set tiflash replica 1;

wait for table available in tiflash

run the following sql:
insert into test.employees(store_id) values (3);
set @@session.tidb_isolation_read_engines = "tiflash"
select * from test.employees

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

+------+----------+
| id | store_id |
+------+----------+
| NULL | 3 |
+------+----------+

3. What did you see instead (Required)

empty result

4. What is your TiDB version? (Required)

+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version() |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v4.0.0-beta.2-921-gb75a30fda
Edition: Community
Git Commit Hash: b75a30f
Git Branch: master
UTC Build Time: 2020-08-09 02:54:26
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

[lidezhu]

Seems caused by this pr: #18981

[cfzjywxk]

@tiancaiamao PTAL

[tiancaiamao]

I can not reproduce it @lidezhu

[lidezhu]

I can not reproduce it @lidezhu

Make sure your tidb version include this pr: #18981

[tiancaiamao]

I can not reproduce it @lidezhu

Make sure your tidb version include this pr: #18981

I see. I get this error in the master branch

mysql> select * from test.employees;
ERROR 1105 (HY000): Do not found result field type for current dag request

[lidezhu]

I can not reproduce it @lidezhu

Make sure your tidb version include this pr: #18981

I see. I get this error in the master branch

mysql> select * from test.employees;
ERROR 1105 (HY000): Do not found result field type for current dag request

This error is caused by using the wrong version of tiflash. Please also use the latest version on master branch for tiflash.

[zanmato1984]

Bump the priority to P0 as this bug blocks TiFlash daily regression and we are have risks that we may miss catching some other bugs by daily regression.