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

James Taylor commented on PHOENIX-3307:
---------------------------------------

+1. Thanks, [~tdsilva]. Please commit to 4.8, 4.x, and master branches.

> Backward compatibility fails for tables with index (4.7.0 client - 4.8.1 
> server)
> --------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3307
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3307
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.9.0, 4.8.1
>            Reporter: Mujtaba Chohan
>            Assignee: Thomas D'Silva
>             Fix For: 4.9.0, 4.8.1
>
>         Attachments: PHOENIX-3307.patch
>
>
> Steps: 
> * With Phoenix 4.7.0 client and server, create index on table that contain 
> schema name
> * Upgrade only server side to Phoenix 4.8.1 
> (https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=0bac1025f37f8c695246e42c47546acfb46c79ef)
> {noformat}
> Error: ERROR 1012 (42M03): Table undefined. tableName=SCH.SCH.T 
> (state=42M03,code=1012)
> org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table 
> undefined. tableName=SCH.SCH.T
>       at 
> org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:414)
>       at 
> org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:285)
>       at 
> org.apache.phoenix.compile.FromCompiler.getResolver(FromCompiler.java:199)
>       at 
> org.apache.phoenix.parse.IndexExpressionParseNodeRewriter.<init>(IndexExpressionParseNodeRewriter.java:45)
>       at 
> org.apache.phoenix.optimize.QueryOptimizer.addPlan(QueryOptimizer.java:233)
>       at 
> org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlans(QueryOptimizer.java:146)
>       at 
> org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:94)
>       at 
> org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:80)
>       at 
> org.apache.phoenix.execute.BaseQueryPlan.getExplainPlan(BaseQueryPlan.java:467)
>       at 
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableExplainStatement.compilePlan(PhoenixStatement.java:456)
>       at 
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableExplainStatement.compilePlan(PhoenixStatement.java:435)
>       at 
> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:263)
>       at 
> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:258)
>       at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>       at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:257)
>       at 
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1297)
> Note: table name was SCH.T and not SCH.SCH.T
> {noformat}
> Following commit caused it:
> https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=71b0b62d98c96870db585f9a232dfb63db3a698d



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

Reply via email to