fixdb

Results 10 comments of fixdb

preprocessor, planner: inline processing by default for single-consumer cte

@elsa0520 issue https://github.com/pingcap/tidb/issues/36295

preprocessor, planner: inline processing by default for single-consumer cte

/merge

preprocessor, planner: inline processing by default for single-consumer cte

/run-mysql-test

Support hint for 1 phase and 2 phase aggregate

/assign @Reminiscent

planner: remove useless selection when the column in where clause is the same as partition clause.

Currently we don't do the optimization to avoid the regression that we might miss some indexes. But we can possibly limit the case to filter where there is only 1...

planner: remove useless selection when the column in where clause is the same as partition clause.

@mjonss @Lloyd-Pottiger How about this? When the partition is list partition, filter is on partition key with eq condition, when there is only 1 condition, or there are multiple conjunctive...

planner: remove useless selection when the column in where clause is the same as partition clause.

> I prefer it is described as there are conditions the same as partition condition in order to solve partition watch_event values in ('WatchEvent','OtherEvent', ...) Looks good. @mjonss What do...

planner: remove useless selection when the column in where clause is the same as partition clause.

@mjonss Sounds good, let's do the filter/condition removal when the conditions match.

planner: the optimizer can't produce an optimal plan for queries with sub-queries in select list since it always decorrelate sub-queries

> We need the rule JoinToApply to do the optimization. Agree, that needs cost based cascades optimizer.

prepared statement failed to fetch rows

@qw4990 Can you cherry-pick to 7.5?