[ https://issues.apache.org/jira/browse/CALCITE-6076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
hongyu guo updated CALCITE-6076: -------------------------------- Description: 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{}}}. was: 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 verification is CatalogScope, not JoinScope. > 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)