[jira] [Commented] (CALCITE-993) Predicate Pull up above Project enhancement

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15027906#comment-15027906 ] 

Jinfeng Ni commented on CALCITE-993:
------------------------------------

Is it possible to apply ReduceExpression to those constant expressions first, such that in the above case, the project just has the int literal of 10?


> Predicate Pull up above Project enhancement
> -------------------------------------------
>
>                 Key: CALCITE-993
>                 URL: https://issues.apache.org/jira/browse/CALCITE-993
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.5.0
>            Reporter: Laljo John Pullokkaran
>            Assignee: Laljo John Pullokkaran
>
> Predicate Pull up on Project can also pull up deterministic functions whose arguments are all literals.
> Ex: select r1.x from (select cast('10' as int) as x, y  from r1 where y<10)r1 join r2 on r1.x=r2.x;
> Currently deterministic functions involving constants are ignored which results in missed transitive inference.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)