[jira] [Created] (PHOENIX-2882) NPE during View creation for table with secondary index

["Sergey Soldatov (JIRA)" <ji...@apache.org>]

Sergey Soldatov created PHOENIX-2882:
----------------------------------------

             Summary: NPE during View creation for table with secondary index 
                 Key: PHOENIX-2882
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2882
             Project: Phoenix
          Issue Type: Bug
            Reporter: Sergey Soldatov


A simple test case:
{noformat}
create table test (id integer primary key, i1 integer, i2 integer);
create index i1 on test (i1);
create view v1 as select * from test where i2 <10;
{noformat}
the thrown exception:
{noformat}
org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=0:I2

	at org.apache.phoenix.schema.PTableImpl.getColumn(PTableImpl.java:692)
	at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:444)
	at org.apache.phoenix.compile.ExpressionCompiler.resolveColumn(ExpressionCompiler.java:366)
	at org.apache.phoenix.compile.WhereCompiler$WhereExpressionCompiler.resolveColumn(WhereCompiler.java:181)
	at org.apache.phoenix.compile.WhereCompiler$WhereExpressionCompiler.visit(WhereCompiler.java:169)
	at org.apache.phoenix.compile.WhereCompiler$WhereExpressionCompiler.visit(WhereCompiler.java:156)
	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.CastParseNode.accept(CastParseNode.java:60)
	at org.apache.phoenix.parse.CompoundParseNode.acceptChildren(CompoundParseNode.java:64)
	at org.apache.phoenix.parse.ComparisonParseNode.accept(ComparisonParseNode.java:45)
	at org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:86)
	at org.apache.phoenix.util.IndexUtil.rewriteViewStatement(IndexUtil.java:494)
	at org.apache.phoenix.schema.MetaDataClient.addIndexesFromPhysicalTable(MetaDataClient.java:739)
	at org.apache.phoenix.schema.MetaDataClient.addTableToCache(MetaDataClient.java:3418)
	at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2279)
	at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:866)
	at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
{noformat}

View created, but any select using view cause a similar exception



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)