Chengpeng Yan comments

Results 42 comments of


                                            Chengpeng Yan

planner: don't push down some conditions to projections

/run-mysql-test tidb-test=pr/1979

planner: don't push down some conditions to projections

/run-check_dev_2

planner: don't push down some conditions to projections

/merge

planner: don't push down some conditions to projections

/run-mysql-test tidb-test=pr/1979

planner: don't push down some conditions to projections

/merge

planner: don't push down some conditions to projections

/run-mysql-test tidb-test=pr/1979

planner: don't push down topN when the expressions in projection is mutable effective

/hold

planner: don't push down topN when the expressions in projection is mutable effective

/merge

planner: don't push down topN when the expressions in projection is mutable effective

/hold

planner: don't push down topN when the expressions in projection is mutable effective

The test case will failed after this PR. ``` drop table t1; create table t1(f1 int, f2 int); insert into t1 values (1,2),(3,1),(2,3); SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); select @var:=f2 from t1...