BerylLin created PHOENIX-2043:
---------------------------------

             Summary: error in using phoenix-client.jar when lowercase column 
name in sql string
                 Key: PHOENIX-2043
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2043
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.4.0
            Reporter: BerylLin


I have met an error when using lowercase column name in sql string in using 
phoenix-client.jar in java.

For example, the sql string is :
select * from users where username = 'Beryl'

I got the error:
org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined 
column. columnName=USERNAME

It seems that the client jar will change all column names to upperclass.

In addition, I can get the correct result when typing the sql in command line 
using sqlline.py

Hope there are some solutions to solve the problem, thank you.



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

Reply via email to