Steve Carlin created IMPALA-15753:
-------------------------------------
Summary: Calcite planner returning wrong value for LIKE with
multiple wildcards
Key: IMPALA-15753
URL: https://issues.apache.org/jira/browse/IMPALA-15753
Project: IMPALA
Issue Type: Bug
Reporter: Steve Carlin
The following query is returning false values for the Calcite planner and true
values for the original planner:
select 'a\\' like 'a\\%%', 'a\%' like 'a\\%%';
The Calcite RexSimplify is changing the multiple wildcard percentage characters
into a single wildcard. But this new string loses the fact that the string
contains a wildcard since the preceding escape characters will turn the
wildcard character into a regular percent character.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
