[SPARK-45060] to_char() fails with an internal error on NULL format

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 02/Sep/23 14:44
• Updated: 05/Sep/23 11:46
• Resolved: 04/Sep/23 07:36

Description

The example below demonstrates the issue:

spark-sql (default)> SELECT to_char(x'537061726b2053514c', CAST(NULL AS STRING));
[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.

Issue Links

• is cloned by: SPARK-45079 percentile_approx() fails with an internal error on NULL accuracy