[ https://issues.apache.org/jira/browse/CALCITE-6076?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17779891#comment-17779891 ]
hongyu guo commented on CALCITE-6076: ------------------------------------- I have dug into the code and git history and found that CALCITE-1309 provides a solution by simply using the LATERAL TABLE keyword. I will close this case. > Table function can not refer other table columns > ------------------------------------------------ > > Key: CALCITE-6076 > URL: https://issues.apache.org/jira/browse/CALCITE-6076 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.35.0 > Reporter: hongyu guo > Assignee: hongyu guo > Priority: Major > > SQL > {code:java} > select rmp.i from emp, table(ramp(emp.deptno)) as rmp {code} > will throw an error: > {code:java} > Table 'EMP' not found {code} > during the validation. > this SQL fails because the scope of the table function during the validation > is {{{}CatalogScope{}}}, not {{{}JoinScope{}}}. -- This message was sent by Atlassian Jira (v8.20.10#820010)