panbingkun commented on code in PR #36855: URL: https://github.com/apache/spark/pull/36855#discussion_r906232203
########## sql/core/src/test/resources/sql-tests/results/ansi/array.sql.out: ########## @@ -191,8 +191,8 @@ select element_at(array(1, 2, 3), 0) -- !query schema struct<> -- !query output -java.lang.ArrayIndexOutOfBoundsException -SQL array indices start at 1 +org.apache.spark.SparkArrayIndexOutOfBoundsException +[INVALID_ARRAY_INDEX_IN_ELEMENT_AT] The index 0 is out of bounds. The array has 3 elements. Use `try_element_at` to tolerate accessing element at invalid index and return NULL instead. If necessary set "spark.sql.ansi.enabled" to "false" to bypass this error. Review Comment: A new error class: ELEMENT_AT_BY_INDEX_ZERO for the case. -- 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]
