Details
-
New Feature
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
3.1.0
-
None
Description
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:
TimeStamp <=> Boolean Date <=> Boolean Numeric <=> Timestamp Numeric <=> Date Numeric <=> Binary String <=> Array String <=> Map String <=> Struct
The following castings are considered invalid in ANSI SQL standard, but they are quite straight forward. Let's Allow them for now
Numeric <=> Boolean String <=> Boolean String <=> Binary
Attachments
Issue Links
- is related to
-
SPARK-38860 ANSI enhancements in Spark 3.3
- Open
- relates to
-
SPARK-35030 ANSI SQL compliance
- Resolved
- links to
(1 links to)