phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maryann Xue (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-9) Incorrect behaviors in choosing index plans and getting results by column names caused by case-sensitive columns
Date Tue, 28 Jan 2014 21:55:35 GMT
Maryann Xue created PHOENIX-9:
---------------------------------

             Summary: 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
            Reporter: Maryann Xue
            Priority: Minor


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)

Mime
View raw message