[PHOENIX-3307] Backward compatibility fails for tables with index (4.7.0 client - 4.8.1 server)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.9.0, 4.8.1
• Fix Version/s: 4.9.0, 4.8.1
• Assignee: Thomas D'Silva
• Reporter: Mujtaba Chohan
• Created: 21/Sep/16 19:31
• Updated: 28/Sep/16 05:15
• Resolved: 22/Sep/16 21:51

Description

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)

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

Following commit caused it:
https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=71b0b62d98c96870db585f9a232dfb63db3a698d

Issue Links

• is related to: PHOENIX-1367 VIEW derived from another VIEW doesn't use parent VIEW indexes