jayzhan211 commented on issue #14943:
URL: https://github.com/apache/datafusion/issues/14943#issuecomment-2695918517
```
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::utils]
simplify_expressions:
Projection: t.a
Filter: CAST(t.b AS Int64) = Int64(4) AND Int64(4) = CAST(t.b AS Int64)
TableScan: t
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::utils]
unwrap_cast_in_comparison:
Projection: t.a
Filter: t.b = Int32(4) AND Int32(4) = t.b
TableScan: t
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::optimizer] Plan unchanged
by optimizer rule 'replace_distinct_aggregate' (pass 0)
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::optimizer] Plan unchanged
by optimizer rule 'eliminate_join' (pass 0)
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::optimizer] Plan unchanged
by optimizer rule 'decorrelate_predicate_subquery' (pass 0)
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::optimizer] Plan unchanged
by optimizer rule 'scalar_subquery_to_join' (pass 0)
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::optimizer] Plan unchanged
by optimizer rule 'extract_equijoin_predicate' (pass 0)
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::optimizer] Plan unchanged
by optimizer rule 'eliminate_duplicated_expr' (pass 0)
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::optimizer] Plan unchanged
by optimizer rule 'eliminate_filter' (pass 0)
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::optimizer] Plan unchanged
by optimizer rule 'eliminate_cross_join' (pass 0)
[2025-03-04T01:01:44Z DEBUG sqlparser::parser] Parsing sql
'__common_expr_1'...
[2025-03-04T01:01:44Z DEBUG sqlparser::parser] Parsing sql
'__common_expr_1'...
[2025-03-04T01:01:44Z DEBUG datafusion_optimizer::utils]
common_sub_expression_eliminate:
Projection: t.a
Projection: t.a, t.b
Filter: __common_expr_1 AND __common_expr_1
Projection: t.b = Int32(4) AS __common_expr_1, t.a, t.b
TableScan: t
```
We simplify A = B and B = A in `common_sub_expression_eliminate` but not
`simplify_expressions`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
