[
https://issues.apache.org/jira/browse/PHOENIX-2798?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor resolved PHOENIX-2798.
-----------------------------------
Resolution: Not A Problem
Most JDBC drivers work this way. The column name provided as the argument to
ResultSet is case sensitive.
> 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
>
> Attachments: PHOENIX-2798.patch
>
>
> 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:sql}
> CREATE TABLE "t"(k INTEGER PRIMARY KEY, v VARCHAR);
> {code}
> {code:java}
> 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)
