Support Lateral derived tables
Open
affects-8.5
compatibility-mysql80
sig/planner
type/compatibility
type/enhancement
type/feature-request
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Feature Request
**Is your feature request related to a problem? Please describe:**
Lateral join is a useful feature introduced in MySQL 8. PostgreSQL also supports it.
**Describe the feature you'd like:**
See details: https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
It is also mentioned in the MySQL 8 compatibility issue: https://github.com/pingcap/tidb/issues/7968
**Describe alternatives you've considered:**
There are some inefficient ways to simulate: https://stackoverflow.com/questions/50563043/how-can-you-simulate-a-lateral-join-in-mysql-v8-to-execute-a-subquery-or-join-fo
**Teachability, Documentation, Adoption, Migration Strategy:**
Contributor guide
Assessment
This issue has not been assessed yet.