[SPARK-39827] add_months() returns a java error on overflow

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 20/Jul/22 12:41
• Updated: 21/Jul/22 10:07
• Resolved: 21/Jul/22 10:07

Description

The code below throws an Java exception, see

spark.sql("SET spark.sql.ansi.enabled=true").show()spark.sql("SELECT add_months('5500000-12-31', 10000000)").show()java.lang.ArithmeticException: integer overflow  at java.base/java.lang.Math.toIntExact(Math.java:1074)  at org.apache.spark.sql.catalyst.util.DateTimeUtils$.localDateToDays(DateTimeUtils.scala:550)  at org.apache.spark.sql.catalyst.util.DateTimeUtils$.dateAddMonths(DateTimeUtils.scala:736) 

but it should throw Spark's exception w/ an error class.

Issue Links

• links to: [Github] Pull Request #37240 (MaxGekk)