Chunwei Lei created CALCITE-3890:
------------------------------------

             Summary: Infer IS NOT NULL predicate from join
                 Key: CALCITE-3890
                 URL: https://issues.apache.org/jira/browse/CALCITE-3890
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Chunwei Lei


We can infer IS NOT NULL predicate from join which implies some columns may not 
be null. For instance, 

 
{code:java}
select * from a join b on a.id = b.id;
{code}
we can infer a.id is not null and b.id is not null.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to