[SPARK-35789] Lateral join should only be used with subquery

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.0
• Component/s: SQL
• Assignee: Allison Wang
• Reporter: Allison Wang
• Created: 16/Jun/21 17:18
• Updated: 17/Jun/21 16:47
• Resolved: 17/Jun/21 16:47

Description

This is a follow up for SPARK-34382. Currently the keyword LATERAL can be used in front of a `relationPrimary`, which consists of more than just subqueries, for example:

select * from t1, lateral t2

Such syntax is not allowed in Postgres. LATERAL should only be used in front of a subquery.

Issue Links

• is a child of: SPARK-34382 ANSI SQL: LATERAL derived table(T491)
• links to: [Github] Pull Request #32937 (allisonwang-db)
• links to: [Github] Pull Request #32937 (allisonwang-db)