[
https://issues.apache.org/jira/browse/CALCITE-993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15042305#comment-15042305
]
Laljo John Pullokkaran commented on CALCITE-993:
------------------------------------------------
[~julianhyde] You are right; we would need to handle NULL generating Functions
differently.
The problem is more wider it seems.
"Case Stmts", UDFs that may generate NULL.
May be we should restrict this to builtin functions that can be guaranteed to
produce non null values given non null literals.
> 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)
