You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Richárd Antal (Jira)" <ji...@apache.org> on 2021/09/29 10:01:00 UTC

[jira] [Assigned] (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 ]

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)