[ https://issues.apache.org/jira/browse/SPARK-30147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Takeshi Yamamuro updated SPARK-30147: ------------------------------------- Parent Issue: SPARK-30375 (was: SPARK-27764) > Trim the string when cast string type to booleans > ------------------------------------------------- > > Key: SPARK-30147 > URL: https://issues.apache.org/jira/browse/SPARK-30147 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Kent Yao > Assignee: Kent Yao > Priority: Major > Fix For: 3.0.0 > > > Now, we trim the string when casting string value to those `canCast` types > values, e.g. int, double, decimal, interval, date, timestamps, except for > boolean. > This behavior makes type cast and coercion inconsistency in Spark. > Not fit ANSI SQL standard either. > {code:java} > If TD is boolean, then > Case: > a) If SD is character string, then SV is replaced by > TRIM ( BOTH ' ' FROM VE ) > Case: > i) If the rules for literal in Subclause 5.3, “literal”, can be applied > to SV to determine a valid > value of the data type TD, then let TV be that value. > ii) Otherwise, an exception condition is raised: data exception — invalid > character value for cast. > b) If SD is boolean, then TV is SV > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org