[SPARK-38177] Fix wrong transformExpressions in Optimizer

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Assignee: XiDuo You
• Reporter: XiDuo You
• Created: 10/Feb/22 14:30
• Updated: 11/Feb/22 04:54
• Resolved: 11/Feb/22 04:54

Description

`transformExpressions` can only traverse all expressions in this current query plan, so the rule `EliminateDistinct` and `EliminateAggregateFilter` can not optimize the non-root node. We should use `transformAllExpressions` rather than `transformExpressions`.

Issue Links

• links to: [Github] Pull Request #35479 (ulysses-you)