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 14:51:00 UTC
[jira] [Resolved] (PHOENIX-6563) Unable to use 'UPPER'/'LOWER'
together with 'IN'
[ https://issues.apache.org/jira/browse/PHOENIX-6563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richárd Antal resolved PHOENIX-6563.
------------------------------------
Fix Version/s: 5.1.3
4.16.2
5.2.0
4.17.0
Resolution: Fixed
> Unable to use 'UPPER'/'LOWER' 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: Major
> Fix For: 4.17.0, 5.2.0, 4.16.2, 5.1.3
>
> 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)