wangyum opened a new pull request, #36713: URL: https://github.com/apache/spark/pull/36713
### What changes were proposed in this pull request? Fix test failure when `SPARK_ANSI_SQL_MODE` is enabled: ``` 2022-05-28T21:02:01.9025896Z - INSERT rows, ALTER TABLE ADD COLUMNS with DEFAULTs, then SELECT them *** FAILED *** (1 second, 260 milliseconds) 2022-05-28T21:02:01.9112619Z org.apache.spark.SparkNumberFormatException: [CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to "TINYINT" because it is malformed. Correct the value as per the syntax, or change its target type. To return NULL instead, use `try_cast`. If necessary set "spark.sql.ansi.enabled" to "false" to bypass this error ``` ### Why are the changes needed? To make CI test pass when `SPARK_ANSI_SQL_MODE` is enabled. ### Does this PR introduce _any_ user-facing change? No. ### How was this patch tested? N/A -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
