[ https://issues.apache.org/jira/browse/PHOENIX-6563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richárd Antal reassigned PHOENIX-6563: -------------------------------------- Assignee: Richárd Antal > Unable to use 'UPPER' together with 'IN' > ---------------------------------------- > > Key: PHOENIX-6563 > URL: https://issues.apache.org/jira/browse/PHOENIX-6563 > Project: Phoenix > Issue Type: Bug > Components: core > Affects Versions: 5.1.2 > Reporter: Vitali Bassov > Assignee: Richárd Antal > Priority: Critical > Attachments: Stacktrace.png > > > Unable to upper case column value and check if it's in the list of values. > Should be two or more values in IN clause. > Example: SELECT * FROM table WHERE UPPER(column_name) IN ('value1', 'value2') -- This message was sent by Atlassian Jira (v8.3.4#803005)