You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Leonid Chistov (Jira)" <ji...@apache.org> on 2023/04/11 12:56:00 UTC
[jira] [Created] (CALCITE-5639) RexSimplify not removes IS NOT NULL check when LIKE comparison is present
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)