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

Column name lookups fail when on an indexed table

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.9.0
    • Fix Version/s: 4.9.0
    • Labels:
      None

      Description

      Using an index the lookup for encoded values fails.

      This happens on tables when using an index.
      The conflict is essentially between the two methods below. The pkColsList create by getPkColsDataTypesForSql() returns column names without a ":", but the encodeValues() method does a lookup on PTable for the column and cannot find it.

      PhoenixRuntime.getPkColsDataTypesForSql(pkColsList, dataTypesList, queryPlan, connection, true);
      PhoenixRuntime.encodeValues(connection, queryPlanTableName, objects , pkColsList);

        Attachments

        1. DebuggerWindow.png
          190 kB
          Cody Marcel
        2. PHOENIX-3421_addendum1.patch
          16 kB
          James R. Taylor
        3. PHOENIX-3421.patch
          9 kB
          James R. Taylor

          Activity

            People

            • Assignee:
              jamestaylor James R. Taylor
              Reporter:
              cody.marcel@gmail.com Cody Marcel
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: