Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
create table t (a int, b int, c int, index ia(a)) partition by hash (a) partitions 16;
select * from t t1 join t t2 on t1.b = t2.b join t t3 on t2.b=t3.b join t t4 on t3.b=t4.b where t3.a=1 and t2.a=2;
select QUERY_SAMPLE_TEXT, plan from information_schema.statements_summary where SCHEMA_NAME = 'test' and STMT_TYPE = 'Select';
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
ref https://github.com/pingcap/tidb/pull/41461
2. What did you expect to see? (Required)
One row in the result
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
master