[
https://issues.apache.org/jira/browse/CALCITE-993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15042331#comment-15042331
]
Julian Hyde commented on CALCITE-993:
-------------------------------------
I have a solution in the branch. If we deduce the type as NOT NULL we will
generate '=', otherwise generate 'IS NOT DISTINCT FROM'. We can (and do) deduce
NOT NULL in the main use case, namely CAST. So, IS NOT DISTINCT FROM will not
occur much in practice.
> 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)
