[CALCITE-6076] Table function can not refer other table columns

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.35.0
• Component/s: core
• Assignee: hongyu guo
• Reporter: hongyu guo
• Created: 26/Oct/23 11:38
• Updated: 26/Oct/23 13:25
• Resolved: 26/Oct/23 13:25

Description

SQL

select rmp.i from emp, table(ramp(emp.deptno)) as rmp 

will throw an error:

Table 'EMP' not found 

during the validation. 

this SQL fails because the scope of the table function during the validation is CatalogScope, not JoinScope.

Issue Links

• relates to: CALCITE-1309 Support LATERAL TABLE