[
https://issues.apache.org/jira/browse/CALCITE-1116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197114#comment-15197114
]
Jesus Camacho Rodriguez edited comment on CALCITE-1116 at 3/16/16 11:27 AM:
----------------------------------------------------------------------------
True, sorry about that, I was thinking about solely about expressions in Filter
operators and I got confused...
Is it safe to transform UNKNOWN to FALSE if the expression above is part of a
Filter condition (as in both cases they will be filtered out)? Or there might
be some side-effects I am not taking into account?
I updated the pull request with a code path for simplifying expressions in
Filter operators, and a different code path for simplifying other expressions.
was (Author: jcamachorodriguez):
True, sorry about that, I got confused...
Is it safe to transform UNKNOWN to FALSE if the expression above is part of a
Filter condition (as in both cases they will be filtered out)? Or there might
be some side-effects I am not taking into account?
> Extend simplify for reducing expressions
> ----------------------------------------
>
> Key: CALCITE-1116
> URL: https://issues.apache.org/jira/browse/CALCITE-1116
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Fix For: 1.7.0
>
>
> We would like to cover more cases in expression simplification, such as:
> x>5 and x is not null => x>5
> x>5 and x is null => not satisfiable
> x>5 and x<=5 => not satisfiable
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
