You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Laljo John Pullokkaran (JIRA)" <ji...@apache.org> on 2015/11/26 00:32:11 UTC

[jira] [Created] (CALCITE-993) Predicate Pull up on Project enhancement

Laljo John Pullokkaran created CALCITE-993:
----------------------------------------------

             Summary: Predicate Pull up on 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)