[SPARK-28023] Trim the string when cast string type to other types

• 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: Yuming Wang
• Created: 12/Jun/19 09:20
• Updated: 09/Aug/20 05:17
• Resolved: 22/Nov/19 11:44

Description

For example:

SELECT bool '   f           ';
select int2 '  21234 ';

Issue Links

• causes: SPARK-32559 Fix the trim logic in UTF8String.toInt/toLong did't handle Chinese characters correctly
• is cloned by: SPARK-30000 Trim the string when cast string type to decimals
• 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