[jira] [Resolved] (PHOENIX-9) Incorrect behaviors in choosing index plans and getting results by column names caused by case-sensitive columns

["Maryann Xue (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-9?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maryann Xue resolved PHOENIX-9.
-------------------------------

    Resolution: Fixed

> Incorrect behaviors in choosing index plans and getting results by column names caused by case-sensitive columns
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-9
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-9
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 2.2.3
>            Reporter: Maryann Xue
>            Priority: Minor
>   Original Estimate: 72h
>  Remaining Estimate: 72h
>
> Suppose we have table t1 and index built on the case-sensitive column "c1":
> 1. When we perform query:
>         SELECT "c1" FROM t1 where "c1" = 'aaa';
> A query plan using index "c1" should be but is NOT used, due to an wrongly raised ColumnNotFoundException with case-sensitive columns.
> 2. When we perform query:
>         SELECT * FROM t1;
> Whether or not an index plan is used, we would end up gettting ColumnNotFoundException when getting the column value for "c1" with method ResultSet#getString("c1").



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)