[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17081169#comment-17081169 ]
Julian Hyde commented on CALCITE-3890: -------------------------------------- I'm worried about adding a configuration parameter. We don't want to end up with hundreds of them. If it makes sense, let's just do it. > 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 > Assignee: Vineet Garg > Priority: Major > > 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)