[jira] [Commented] (CALCITE-2382) Column not found when subquery join lateral table function

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16524044#comment-16524044 ] 

Julian Hyde commented on CALCITE-2382:
--------------------------------------

Might be a duplicate of CALCITE-531. Can you please test on top of my https://github.com/julianhyde/calcite/commit/f75a212d49040bc953aa1b5e1f0c3bd6da9c31b9 dev branch, and let me know whether it works. Whether or not it works, please contribute a test to TableFunctionTest.

> Column not found when subquery join lateral table function
> ----------------------------------------------------------
>
>                 Key: CALCITE-2382
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2382
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.16.0
>            Reporter: pengzhiwei
>            Assignee: Julian Hyde
>            Priority: Critical
>
> When using subquery join lateral table function as followed:
>  
> {code:java}
>  select * from ( select 5 as f0 from s.t ) a,lateral table(s.GenerateStrings(f0)) as t(n, c)  where char_length(c) > 3
> {code}
> 'SqlValidatorException: Column 'F0' not found in any table'  was thrown out.
> I find the reason is that  SqlValidatorImpl add the namespace of Identifier 's.t'  to the children of tableScope,but not the subquey's namespace,just as the code show bellow in  SqlValidatorImpl#registerFrom:
> {code:java}
> case IDENTIFIER:
>   ...........
>   if (tableScope == null) {
>   tableScope = new TableScope(parentScope, node);
>   }
>  tableScope.addChild(newNs, alias, forceNullable);{code}
> I think the namespace of  JoinScope's left child should be  the children of tableScope which was referenced by the table function,just as the code show bellow in  SqlValidatorImpl#registerFrom:
> {code:java}
> case COLLECTION_TABLE:
>   ....
>   TableScope tableScope = null;
>   if(parentScope instanceof JoinScope) {
>   tableScope = new TableScope(new EmptyScope(this),operand);
>   JoinScope scope = (JoinScope) parentScope;
>   SqlValidatorNamespace leftNs = scope.getChildren().get(0);
>   tableScope.addChild(leftNs,scope.children.get(0).name,forceNullable);
> }
> ....{code}
> After this modification,the case upon runs well.
> Is there any problem for this modification? Any suggestions is welcomed.Thanks a lot.
>  
>  
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)