READ_FROM_STORAGE conflicting with access path pruning logic causes Internal : Can't find a proper physical plan for this query error

[time-and-fate]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(a int, b int, c int, d int, unique key (a) ,index ii(a,b));
alter table t set tiflash replica 1;
-- wait for the tiflash replica ready
explain select  /*+ READ_FROM_STORAGE(TIFLASH[t]) */ a from t where a = 10 and b is null;

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

Display the execution plan.

3. What did you see instead (Required)

ERROR 1815 (HY000): Internal : Can't find a proper physical plan for this query

4. What is your TiDB version? (Required)

From at least v5.3.0 to master.

TiDB before v5.3.0 might also be affected but I can't verify it on my machine.