[SPARK-44391] `url_decode` can fail w/ an internal error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.5.0
• Fix Version/s: 3.4.2, 3.5.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 12/Jul/23 15:54
• Updated: 14/Jul/23 05:38
• Resolved: 13/Jul/23 09:17

Description

The function url_decode can fail with the error:

org.apache.spark.SparkException: [INTERNAL_ERROR] The Spark SQL phase analysis failed with an internal error. You hit a bug in Spark or the Spark plugins you use. Please, report this bug to the corresponding communities or vendors, and provide the full stack trace. 
at org.apache.spark.SparkException$.internalError(SparkException.scala:89) 
at org.apache.spark.sql.execution.QueryExecution$.toInternalError(QueryExecution.scala:871) 
...
Caused by: java.lang.AssertionError: assertion failed: Incorrect number of children
        at scala.Predef$.assert(Predef.scala:223)
        at org.apache.spark.sql.catalyst.trees.TreeNode.withNewChildren(TreeNode.scala:391)
        at org.apache.spark.sql.catalyst.analysis.TypeCoercionBase$ImplicitTypeCasts$$anonfun$11.applyOrElse(TypeCoercion.scala:707)

Issue Links

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