[jira] [Resolved] (CALCITE-2382) Column not found when sub-query joins lateral table function

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

     [ https://issues.apache.org/jira/browse/CALCITE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde resolved CALCITE-2382.
----------------------------------
    Resolution: Fixed

Fixed in [ccbc656d| http://git-wip-us.apache.org/repos/asf/calcite/commit/ccbc656d]. Thanks for the PR and suggested fix, [~pzw2018]!

> Column not found when sub-query joins 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
>             Fix For: 1.17.0
>
>         Attachments: 屏幕快照 2018-06-27 下午12.39.46.png
>
>
> # 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)