You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Runkang He (Jira)" <ji...@apache.org> on 2023/06/14 14:27:00 UTC
[jira] [Assigned] (CALCITE-5780) Always-true OR expressions contains reverse order comparison should be simplified to TRUE
[ https://issues.apache.org/jira/browse/CALCITE-5780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Runkang He reassigned CALCITE-5780:
-----------------------------------
Assignee: Runkang He
> Always-true OR expressions contains reverse order comparison should be simplified to TRUE
> -----------------------------------------------------------------------------------------
>
> Key: CALCITE-5780
> URL: https://issues.apache.org/jira/browse/CALCITE-5780
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.34.0
> Reporter: Runkang He
> Assignee: Runkang He
> Priority: Major
>
> The following expressions which contains reverse order comparison are always true:
> {code:sql}
> 1 > x or 1 <= x or x is null
> 1 < x or 1 >= x or x is null
> 1 > x or 0 < x or x is null
> {code}
> But currently these expressions are not fully simplified to TRUE, the current simplified results are SEARCH operator.
> The root cause is that RexSimplify doesn't identify these cases and makes targeted simplification.
> It would be nice if RexSimplify.simplifyOr handled these cases.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)