[jira] [Resolved] (CALCITE-1995) Remove predicates from Filter if they can be proved to be always true or false

["Julian Hyde (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-1995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde resolved CALCITE-1995.
----------------------------------
       Resolution: Fixed
    Fix Version/s: 1.15.0

Fixed in [a9ac3e4|http://git-wip-us.apache.org/repos/asf/calcite/commit/a9ac3e486863b36009a6e5e0f066134ad34b3334], but there is a follow-up issue CALCITE-2074.

> Remove predicates from Filter if they can be proved to be always true or false
> ------------------------------------------------------------------------------
>
>                 Key: CALCITE-1995
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1995
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>             Fix For: 1.15.0
>
>
> Remove predicates from Filter if they can be proved to be always true or false. For example, the query
> {code}
> select *
> from (select * from emp where deptno > 10)
> where  empno > 3 and deptno > 5
> {code}
> can be simplified to
> {code}
> select *
> from (select * from emp where deptno > 10)
> where  empno > 3
> {code}
> because {{deptno > 5}} can be proved to be always true, due the predicate {{deptno > 10}} on its input relational expression.
> Implement this by expanding the capabilities of {{FilterReduceExpressionsRule}}.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)