[IMPALA-2422] % escaping does not work correctly in a LIKE clause

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: Impala 2.2.4, Impala 2.3.0, Impala 2.5.0, Impala 2.4.0, Impala 2.6.0, Impala 2.7.0
• Component/s: Backend, Frontend
• Labels: 2023Q1 correctness downgraded incompatibility
• Assignee: Unassigned
• Reporter: Huaisi Xu
• Created: 25/Sep/15 07:19
• Updated: 07/Sep/23 22:24

Description

[localhost:21000] > select '%' like "\%";
Query: select '%' like "\%"
+---------------+
| '%' like '\%' |
+---------------+
| false           |       -> should return true.
+---------------+
Fetched 1 row(s) in 0.01s

Issue Links

• is related to: IMPALA-7586 Incorrect results when querying primary = "\"" in Kudu and HBase
• is related to: IMPALA-6096 RLIKE/REGEXP operator and regexp_* functions require different character escaping
• relates to: HIVE-12901 Incorrect result from select '\\' like '\\%'
• relates to: IMPALA-1768 Add ESCAPE to LIKE