Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3307

Backward compatibility fails for tables with index (4.7.0 client - 4.8.1 server)

    XMLWordPrintableJSON

    Details

    • 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
    • Labels:
      None

      Description

      Steps:

      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

        Attachments

        1. PHOENIX-3307.patch
          65 kB
          Thomas D'Silva

          Issue Links

            Activity

              People

              • Assignee:
                tdsilva Thomas D'Silva
                Reporter:
                mujtabachohan Mujtaba Chohan
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: