andygrove opened a new issue, #2215: URL: https://github.com/apache/datafusion-comet/issues/2215
### What is the problem the feature request solves? Spark includes the original SQL query in error messages with hints to which part of the query failed. ``` scala> spark.sql("select cast('a' as date)").show() org.apache.spark.SparkDateTimeException: [CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to "DATE" because it is malformed. Correct the value as per the syntax, or change its target type. Use `try_cast` to tolerate malformed input and return NULL instead. SQLSTATE: 22018 == SQL (line 1, position 8) == select cast('a' as date) ``` Comet does not do this: ``` org.apache.comet.CometNativeException: [CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to "DATE" because it is malformed. Correct the value as per the syntax, or change its target type. Use `try_cast` to tolerate malformed input and return NULL instead. If necessary set "spark.sql.ansi.enabled" to "false" to bypass this error. ``` Therefore we see test failures such as: ``` did not contain "select cast(s as date) from t" ``` Example test (Spark 4.0.0 in ANSI mode) ``` SPARK-39175: Query context of Cast should be serialized to executors when WSCG is off *** FAILED *** ``` ### Describe the potential solution _No response_ ### Additional context _No response_ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org