Datafusion Optimizer Enhancement

[jackwener]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.

Enhance Optimizer Summary:

• Optimizer: Predicate Rewrite pass for TPCH Q19 #217
• Move filter predicate to join conversion to optimization rule #475
• LogicalPlan Optimizer: Push <col> = <col> predicates into Joins, if possible #1612
• convert outer join to inner join to improve performance #1585
• Support predicate pruning on Expr::Case expressions #1692
• Optimizer: IS NULL optimization #1342
• [Optimizer] Infer is not null predicate from where clause #2254
• [Optimizer] Eliminate self compare self #2252
• [Optimizer] Eliminate the distinct #2045
• Eliminate Unsatisfiable Boolean Expressions #1716
• [Optimizer] Refactor convert join #2256

Describe the solution you'd like

Describe alternatives you've considered

Additional context

[jackwener]

At present, a big problem is the limitation of schema on transformation.

We should consider schema change detail after transformation. In fact, I often meet problems in this like #2084, and I can't solve it because it is hard to debug. I will try fix them gradually.

[jackwener]

BTW, If you find other optimizer enhancement isn't in it, feel free ping me add it by @jackwener