planner support NullAware-LeftOuterSemi Join for tiflash
Open
sig/planner
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
planner doesn't support NullAware-LeftOuterSemi, check the following plan, `CARTESIAN LeftOuterSemi` is used instead of `NullAware LeftOuterSemi`.
Because tidb executor doesn't support `NullAware LeftOuterSemi` for now, but tiflash has supported it, check
https://github.com/pingcap/tiflash/blob/dce9588b0512a6aaeaac98ac7d65e9102a664f26/dbms/src/Interpreters/Join.cpp#L1521-L1523
So we can enable `NullAware LeftOuterSemi` for tiflash.
Contributor guide
Assessment
This issue has not been assessed yet.