[jira] [Created] (CALCITE-2879) Improve filter condition in Join

[yuqi (JIRA)]

yuqi created CALCITE-2879:
-----------------------------

             Summary: Improve filter condition in Join
                 Key: CALCITE-2879
                 URL: https://issues.apache.org/jira/browse/CALCITE-2879
             Project: Calcite
          Issue Type: Improvement
            Reporter: yuqi


Currently, filter condition in join have not been optimized very well, let's 
take a simple example


{code:sql}
select a.id, b.name from Ta a inner join Tb b on a.id = b.id and a.id < 5;

{code}

now, only a.id < 5 can push down, however, as for the sql above,  
we can infer a.id < 5 and b.id < 5 and both of them can push down. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)