[
https://issues.apache.org/jira/browse/PHOENIX-2798?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kevin Liew updated PHOENIX-2798:
--------------------------------
Description:
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}
was:
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}
> 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: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)
