[SPARK-36073] EquivalentExpressions fixes and improvements

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Assignee: Peter Toth
• Reporter: Peter Toth
• Created: 09/Jul/21 11:55
• Updated: 11/Nov/21 04:49
• Resolved: 11/Nov/21 04:49

Description

Currently `EquivalentExpressions` has 2 issues:

• identifying common expressions in conditional expressions is not correct in all cases
• transparently canonicalized expressions (like `PromotePrecision`) are considered common subexpressions

Issue Links

• links to: [Github] Pull Request #33281 (peter-toth)
• links to: [Github] Pull Request #33281 (peter-toth)