[jira] [Created] (CALCITE-5639) RexSimplify not removes IS NOT NULL check when LIKE comparison is present

["Leonid Chistov (Jira)" <ji...@apache.org>]

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)