phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cody Marcel (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-3421) Column name lookups fail when on an indexed table
Date Tue, 01 Nov 2016 14:39:59 GMT


Cody Marcel commented on PHOENIX-3421:

[~jamestaylor] That should work for now. Ideally though, we would pass in a standard PreparedStatement
and Phx would convert that into it's internal QueryPlan. We are coming up with a list of API
we think would be good for public use.

> Column name lookups fail when on an indexed table
> -------------------------------------------------
>                 Key: PHOENIX-3421
>                 URL:
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.8.0
>            Reporter: Cody Marcel
>            Assignee: James Taylor
>             Fix For: 4.9.0
>         Attachments: DebuggerWindow.png, PHOENIX-3421.patch
> 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,
> PhoenixRuntime.encodeValues(connection, queryPlanTableName, objects , pkColsList);

This message was sent by Atlassian JIRA

View raw message