[
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)
