Let Index Join support use simple Aggregation on Table as its inner child
Open
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
In oracle, the SQL like `select ... from t, (select ... from t1 group by a) where t.a = t1.a`. It can apply index join to let table `t` as the outer child and the `Aggregation(t1)` as the inner child.
This is a case that TiDB doesn't support yet.
Contributor guide
Assessment
This issue has not been assessed yet.