[SPARK-30000] Trim the string when cast string type to decimals

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Kent Yao 2
• Reporter: Kent Yao 2
• Created: 22/Nov/19 11:55
• Updated: 25/Nov/19 05:22
• Resolved: 25/Nov/19 05:22

Description

https://bugs.openjdk.java.net/browse/JDK-8170259
https://bugs.openjdk.java.net/browse/JDK-8170563

When we cast string type to decimal type, we rely on java.math. BigDecimal. It can't accept leading and training spaces, as you can see in the above links. This behavior is not consistent with other numeric types now. we need to fix it and keep consistency.

Issue Links

• is a clone of: SPARK-28023 Trim the string when cast string type to other types
• is duplicated by: SPARK-29980 Whitespaces handling for Cast and BinaryOperation between StringType and NumericTypes
• is related to: SPARK-27931 Accept 'on' and 'off' as input for boolean data type
• is related to: SPARK-25098 Trim the string when cast stringToTimestamp and stringToDate
• links to: GitHub Pull Request #24872
• links to: GitHub Pull Request #26622
• links to: GitHub Pull Request #26640