[jira] [Updated] (CALCITE-6076) Table function can not refer other table columns

[hongyu guo (Jira)]

 [ 
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)

[jira] [Updated] (CALCITE-6076) Table function can not refer other table columns

[hongyu guo (Jira)]

 [ 
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 verification 
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 
> verification is CatalogScope, not JoinScope.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)