[CALCITE-1309] Support LATERAL TABLE

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Jark Wu
• Created: 08/Jul/16 02:52
• Updated: 27/Feb/24 22:23
• Resolved: 29/Aug/16 22:47

Description

SELECT MyTable.*, t.s  FROM MyTable, LATERAL TABLE(split(MyTable.a)) AS t(s)

will throw “Encountered "LATERAL TABLE" at line 1, column 38.” exception.

We should support LATERAL TABLE , and allow table function to see earlier tables in the FROM clause.

Issue Links

• is related to: CALCITE-6076 Table function can not refer other table columns
• relates to: CALCITE-531 Window function does not work in LATERAL
• relates to: CALCITE-1356 Release Calcite 1.9.0