Ted Xu created CALCITE-1920:
-------------------------------
Summary: Add IS_NOT_NULL predicate on not-nullable equi-join keys
Key: CALCITE-1920
URL: https://issues.apache.org/jira/browse/CALCITE-1920
Project: Calcite
Issue Type: Improvement
Affects Versions: 1.13.0
Reporter: Ted Xu
Assignee: Julian Hyde
In equi-joins, if the join keys are not-nullable according to join type, we can
assign a IS_NOT_NULL predicate to reduce input. For example, query:
{code:sql}
select * from src1 join src2 on src1.id = src2.id
{code}
can be rewrite to
{code:sql}
select * from
(select * from src1 where src1.id is not null) src1
join
(select * from src2 where src2.id is not null) src2
on src1.id = src2.id
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
