[ https://issues.apache.org/jira/browse/SPARK-33354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17280988#comment-17280988 ]
Apache Spark commented on SPARK-33354: -------------------------------------- User 'gengliangwang' has created a pull request for this issue: https://github.com/apache/spark/pull/31523 > New explicit cast syntax rules in ANSI mode > ------------------------------------------- > > Key: SPARK-33354 > URL: https://issues.apache.org/jira/browse/SPARK-33354 > Project: Spark > Issue Type: New Feature > Components: SQL > Affects Versions: 3.1.0 > Reporter: Gengliang Wang > Assignee: Gengliang Wang > Priority: Major > Fix For: 3.1.0 > > > In section 6.13 of the ANSI SQL standard, there are syntax rules for valid > combinations of the source and target data types. > To make Spark's ANSI mode more ANSI SQL Compatible,I propose to disallow the > following casting in ANSI mode: > {code:java} > TimeStamp <=> Boolean > Date <=> Boolean > Numeric <=> Timestamp > Numeric <=> Date > Numeric <=> Binary > String <=> Array > String <=> Map > String <=> Struct > {code} > The following castings are considered invalid in ANSI SQL standard, but they > are quite straight forward. Let's Allow them for now > {code:java} > Numeric <=> Boolean > String <=> Boolean > String <=> Binary > {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