[ https://issues.apache.org/jira/browse/PHOENIX-3307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15510923#comment-15510923 ]
Mujtaba Chohan commented on PHOENIX-3307: ----------------------------------------- FYI [~larsh] > 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 > Fix For: 4.9.0, 4.8.1 > > > 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)