You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Rui Wang <am...@apache.org> on 2019/11/21 23:37:01 UTC

SqlValidator: given a scope, how to resolve a column name?

Hi community,


SqlValidatorScope defines RelDataType resolveColumn(String name, SqlNode ctx
) to help resolve a column name in scope and return its type. However, in
the implementation that is used during validation phase, which is
EmptyScope, the implementation returns null directly (see [2]).

Is it intentional to return null for the implementation of EmptyScope? Is
there an alternative way to achieve what resolveColumn is designed for, or
I have to implement that in EmptyScope to be able to use it?



[1]:
https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/validate/SqlValidatorScope.java#L161

[2]:
https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/validate/EmptyScope.java#L189

-Rui

Re: SqlValidator: given a scope, how to resolve a column name?

Posted by Julian Hyde <jh...@apache.org>.
If you have hit EmptyScope, that probably means that the validator has tried other scopes and found nothing. Usually (e.g. inside a SELECT clause) the validator uses a ListScope, with the tables in the FROM clause making up the list of namespaces in which to search for columns. Each scope has a parent that it delegates to if it finds nothing, and EmptyScope is the end of the line.

Julian


> On Nov 21, 2019, at 3:37 PM, Rui Wang <am...@apache.org> wrote:
> 
> Hi community,
> 
> 
> SqlValidatorScope defines RelDataType resolveColumn(String name, SqlNode ctx
> ) to help resolve a column name in scope and return its type. However, in
> the implementation that is used during validation phase, which is
> EmptyScope, the implementation returns null directly (see [2]).
> 
> Is it intentional to return null for the implementation of EmptyScope? Is
> there an alternative way to achieve what resolveColumn is designed for, or
> I have to implement that in EmptyScope to be able to use it?
> 
> 
> 
> [1]:
> https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/validate/SqlValidatorScope.java#L161
> 
> [2]:
> https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/validate/EmptyScope.java#L189
> 
> -Rui