For query: ``` select t1.id, t1.value, t2.value from t1 left join t2 on t1.id = t2.id where t1.id > 1 ``` We infer new predicate `t2.id > 1` and pushdown it to t2 Scannode.