You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Chunwei Lei (Jira)" <ji...@apache.org> on 2020/04/01 04:10:00 UTC

[jira] [Created] (CALCITE-3890) Infer IS NOT NULL predicate from join

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)