[SPARK-37631] Code clean up on promoting strings in math functions

• Type: Task
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Assignee: Gengliang Wang
• Reporter: Gengliang Wang
• Created: 13/Dec/21 15:27
• Updated: 14/Dec/21 03:07
• Resolved: 14/Dec/21 03:07

Description

There is some similar logic in promoting string to double type in TypeCoercion and AnsiTypeCoercion.

We can change the function Abs/UnaryMinus/UnaryPositive to extend 

ImplicitCastInputTypes so that string will implicitly cast to Double type in the rule `ImplicitTypeCasts`.  We don't have to repeat the logic in rule `PromoteStrings` or `PromoteStringLiterals`

Issue Links

• links to: [Github] Pull Request #34884 (gengliangwang)