[
https://issues.apache.org/jira/browse/CALCITE-3842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17051949#comment-17051949
]
Chunwei Lei commented on CALCITE-3842:
--------------------------------------
It's by design, not a bug. For (a <= 10) OR (a <= 1), RexSimplify would take
a>10 as a predicate(because of short-circuit) when simplifying a<=1. So a<=1
can be simplified. But as for (a <= 1) OR (a <= 10), RexSimplify take a>1 as
predicate, which doesn't help simplify a<=10.
Maybe we can make some improvements.
> Simplification of OR condition is based on order of operands.
> -------------------------------------------------------------
>
> Key: CALCITE-3842
> URL: https://issues.apache.org/jira/browse/CALCITE-3842
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: anjali shrishrimal
> Priority: Major
>
> RexSimplify simplifies :
> {noformat}
> (a <= 10) OR (a <= 1) --> a <= 10{noformat}
> but does not simplify
> {noformat}
> (a <= 1) OR (a <= 10) {noformat}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
