xudong.w

Migrate the `cross join -> inner join optimization` from the planner to the optimizer

1

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** Migrate the cross join -> inner join optimization from the planner to...

**Summary** Currently, `20_0001_planner_v2` contains all kinds of tests, I think it's better to classify them. I have picked join-related tests from `20_0001_planner_v2` to `join.test` in https://github.com/datafuselabs/databend/pull/7086 cc @ZeaLoVe

### Search before asking - [X] I had searched in the [issues](https://github.com/datafuselabs/databend/issues) and found no similar issues. ### Version main ### What's Wrong? ```sql select * from (SELECT number AS...

Feature: explain support `ExplainKind` free combination

1

**Summary** Such as ```sql explain (fragments, pipeline) select * from t; explain (syntax, fragments) select * from t; ```

**Summary** Need RFC. Currently, databend processes CTE by inlining all references to CTEs in the query tree. This causes the CTE to execute multiple, but further optimization can be done...

**Summary** https://www.postgresql.org/docs/current/queries-union.html (We have supported `intersect` and `except` set operator.) `Union` also is used in recursive CTE.

**Summary** Description for this feature.

Feature: use goldenfile for logictest file

2

**Summary** Small changes may require modification of multiple logic tests results Manually changing them one by one is too painful :(

**Summary** TPCH q4 will be converted to semi join ```sql MySQL [tpch]> explain -> select -> o_orderpriority, -> count(*) as order_count -> from -> orders -> where -> o_orderdate >=...