yuqi created CALCITE-2879: ----------------------------- Summary: Improve filter condition in Join Key: CALCITE-2879 URL: https://issues.apache.org/jira/browse/CALCITE-2879 Project: Calcite Issue Type: Improvement Reporter: yuqi
Currently, filter condition in join have not been optimized very well, let's take a simple example {code:sql} select a.id, b.name from Ta a inner join Tb b on a.id = b.id and a.id < 5; {code} 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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)