support join reorder for semi join
Open
report/customer
sig/planner
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
check the case from https://github.com/pingcap/tidb/issues/67467
tidb generate the bad plan because we didn't support reorder semi join for now, we'd better support it. Because using `semi_join_rewrite()` hint is not suitable for all situations.
Contributor guide
Assessment
This issue has not been assessed yet.