[ https://issues.apache.org/jira/browse/CALCITE-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez resolved CALCITE-2240. ---------------------------------------------- Resolution: Fixed Fix Version/s: 1.17.0 Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/9e07f13 . > Extend rule to push predicates into CASE statement > -------------------------------------------------- > > Key: CALCITE-2240 > URL: https://issues.apache.org/jira/browse/CALCITE-2240 > Project: Calcite > Issue Type: Bug > Reporter: Zoltan Haindrich > Assignee: Zoltan Haindrich > Priority: Major > Fix For: 1.17.0 > > > [CaseShuttle|https://github.com/apache/calcite/blob/8139acb78b100483fbafb078fb82d07f921abef0/core/src/main/java/org/apache/calcite/rel/rules/ReduceExpressionsRule.java#L562] > may make the optimization but the functions return value doesn't depend on > that. > For the following query the =1 is not pushed into the case. > {code} > select empno from emp where case when sal > 1000 then empno else sal end = 1 > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)