Re: Question about PredicateTransitivePropagate

2015-08-19 Thread 孙若曦
To: "user"; "dev"; Cc: "孙若曦"; Subject: Re: Question about PredicateTransitivePropagate >select * from t1 join t2 on t1.col = t2.col where t1.col = 1; > Is rule PredicateTransitivePropagate supposed to propagate predicate >"t1.col = 1" to t2 via

Re: Question about PredicateTransitivePropagate

2015-08-18 Thread Gopal Vijayaraghavan
>select * from t1 join t2 on t1.col = t2.col where t1.col = 1; > Is rule PredicateTransitivePropagate supposed to propagate predicate >"t1.col = 1" to t2 via join condition t1.col = t2.col? > Assuming so, I found that the predicate "t1.col = 1" has not been pushed >down to table scan of t1, thus Pr

Question about PredicateTransitivePropagate

2015-08-18 Thread 孙若曦
For cases like: select * from t1 join t2 on t1.col = t2.col where t1.col = 1; Is rule PredicateTransitivePropagate supposed to propagate predicate "t1.col = 1" to t2 via join condition t1.col = t2.col? Assuming so, I found that the predicate "t1.col = 1" has not been pushed down to table scan of