[
https://issues.apache.org/jira/browse/IMPALA-12581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on IMPALA-12581 started by Ye Zihao.
-----------------------------------------
> ILIKE and IREGEXP don't work with non-const argument values
> -----------------------------------------------------------
>
> Key: IMPALA-12581
> URL: https://issues.apache.org/jira/browse/IMPALA-12581
> Project: IMPALA
> Issue Type: Bug
> Components: be
> Affects Versions: Impala 4.3.0
> Reporter: Peter Rozsa
> Assignee: Ye Zihao
> Priority: Critical
>
> ILIKE and IREGEXP's backend implementation does not set the case-insensitive
> flag when the argument value is non-constant.
> Example:
> {code:java}
> create table ilike_test (x string, y string);
> insert into ilike_test values ('ABC','b');
> select x ilike concat('%', y, '%') from ilike_test;{code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
