You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Ye Zihao (Jira)" <ji...@apache.org> on 2023/12/13 06:21:00 UTC
[jira] [Commented] (IMPALA-12581) ILIKE and IREGEXP don't work with non-const argument values
[ https://issues.apache.org/jira/browse/IMPALA-12581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17796020#comment-17796020 ]
Ye Zihao commented on IMPALA-12581:
-----------------------------------
reviewed on: https://gerrit.cloudera.org/#/c/20785/
> 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org