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)