Leonid Chistov created CALCITE-5639:
---------------------------------------
Summary: RexSimplify not removes IS NOT NULL check when LIKE
comparison is present
Key: CALCITE-5639
URL: https://issues.apache.org/jira/browse/CALCITE-5639
Project: Calcite
Issue Type: Bug
Affects Versions: 1.34.0
Reporter: Leonid Chistov
Assignee: Leonid Chistov
Consider query likeselect r_reason_desc from reason where r_reason_desc is not
null and r_reason_desc like '%child%' desc is not null and r_reason_desc like
'%child%'
where `r_reason_desc` is a nullable field.
When `RexSimplify::simplifyFilterPredicates` is called on that conjunction of
expressions, expression is not simplified, meaning that redundant `is not
null` check is not removed.
In the same time, if query like
{code:java}
select r_reason_desc from reason
where r_reason_desc is not null and r_reason_desc like '%child%' {code}
is passed to optimizer, redundant `is not null` check is eliminated.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
