You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Vitali Bassov (Jira)" <ji...@apache.org> on 2021/09/27 11:47:00 UTC
[jira] [Updated] (PHOENIX-6563) Unable to use 'UPPER' together with
'IN'
[ https://issues.apache.org/jira/browse/PHOENIX-6563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vitali Bassov updated PHOENIX-6563:
-----------------------------------
Description:
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')
> Unable to use 'UPPER' together with 'IN'
> ----------------------------------------
>
> Key: PHOENIX-6563
> URL: https://issues.apache.org/jira/browse/PHOENIX-6563
> Project: Phoenix
> Issue Type: Bug
> Reporter: Vitali Bassov
> Priority: Major
>
> 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)