[CALCITE-2879] Improve filter condition in Join

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: yuqi
• Created: 27/Feb/19 13:17
• Updated: 05/Jul/19 12:38
• Resolved: 05/Jul/19 12:38

Description

Currently, filter condition in join have not been optimized very well, let's take a simple example

select a.id, b.name from Ta a inner join Tb b on a.id = b.id and a.id < 5;

now, only a.id < 5 can push down, however, as for the sql above,
we can infer a.id < 5 and b.id < 5 and both of them can push down.

Issue Links

• links to: GitHub Pull Request #1072