[jira] [Assigned] (PHOENIX-2798) Case insensitive column on case sensitive table fails to find column in result set

["Kevin Liew (JIRA)" <ji...@apache.org>]

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

Kevin Liew reassigned PHOENIX-2798:
-----------------------------------

    Assignee: Kevin Liew

> Case insensitive column on case sensitive table fails to find column in result set
> ----------------------------------------------------------------------------------
>
>                 Key: PHOENIX-2798
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2798
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: Kevin Liew
>             Fix For: 4.10.0
>
>
> If a table is created as case sensitive, but the columns are case insensitive, then the ResultSet fails to find a mixed case column.
> For example:
> {code}
> CREATE TABLE "t"(k INTEGER PRIMARY KEY, v VARCHAR);
> ResultSet rs = conn.createStatement().executeQuery("SELECT k FROM \"t\"")
> rs.next();
> rs.getInt("k");
> rs.getString("v");
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)