You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Jaanai (JIRA)" <ji...@apache.org> on 2018/09/13 06:23:00 UTC

[jira] [Created] (PHOENIX-4904) NPE exception when use non-existing filed in function

Jaanai created PHOENIX-4904:
-------------------------------

             Summary: NPE exception when use non-existing filed in function 
                 Key: PHOENIX-4904
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4904
             Project: Phoenix
          Issue Type: New Feature
    Affects Versions: 4.14.0, 4.13.0, 4.12.0
            Reporter: Jaanai
            Assignee: Jaanai


Using following SQL to reoccur error:

{code:sql}
create table "test_truncate"("ROW" varchar primary key,"f"."0" varchar,"f"."1" varchar);
select * from "test_truncate" order by TO_NUMBER("f.1");
{code}

Exception information:

{code}
java.lang.NullPointerException     at org.apache.phoenix.util.SchemaUtil.getSchemaNameFromFullName(SchemaUtil.java:632)     at org.apache.phoenix.schema.TableNotFoundException.(TableNotFoundException.java:44)     at org.apache.phoenix.compile.FromCompiler$MultiTableColumnResolver.resolveTable(FromCompiler.java:858)     at org.apache.phoenix.compile.FromCompiler$ProjectedTableColumnResolver.resolveColumn(FromCompiler.java:984)     at org.apache.phoenix.compile.ExpressionCompiler.resolveColumn(ExpressionCompiler.java:372)     at org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:408)     at org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:146)     at org.apache.phoenix.parse.ColumnParseNode.accept(ColumnParseNode.java:56)     at org.apache.phoenix.parse.CompoundParseNode.acceptChildren(CompoundParseNode.java:64)     at org.apache.phoenix.parse.FunctionParseNode.accept(FunctionParseNode.java:84)     at org.apache.phoenix.compile.OrderByCompiler.compile(OrderByCompiler.java:123)     at org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:562)     at org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:507)     at org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:202)     at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:157)     at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:478)     at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:444)     a
{code}




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