[IMPALA-12581] ILIKE and IREGEXP don't work with non-const argument values

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 4.3.0
• Fix Version/s: Impala 4.4.0
• Component/s: Backend
• Epic Color: ghx-label-4
• Assignee: Zihao Ye
• Reporter: Peter Rozsa
• Created: 28/Nov/23 17:03
• Updated: 16/Jul/24 23:54
• Resolved: 05/Jan/24 02:22

Description

ILIKE and IREGEXP's backend implementation does not set the case-insensitive flag when the argument value is non-constant.

Example:

create table ilike_test (x string, y string);
insert into ilike_test values ('ABC','b');
select x ilike concat('%', y, '%') from ilike_test;