[SPARK-38750] Test the error class: SECOND_FUNCTION_ARGUMENT_NOT_INTEGER

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Labels: starter
• Assignee: Pan Bingkun
• Reporter: Max Gekk
• Shepherd: Max Gekk
• Created: 31/Mar/22 20:14
• Updated: 23/Apr/22 06:12
• Resolved: 23/Apr/22 06:12

Description

Add a test for the error classes SECOND_FUNCTION_ARGUMENT_NOT_INTEGER to QueryCompilationErrorsSuite. The test should cover the exception throw in QueryCompilationErrors:

  def secondArgumentOfFunctionIsNotIntegerError(
      function: String, e: NumberFormatException): Throwable = {
    // The second argument of '{function}' function needs to be an integer
    new AnalysisException(
      errorClass = "SECOND_FUNCTION_ARGUMENT_NOT_INTEGER",
      messageParameters = Array(function),
      cause = Some(e))
  }

For example, here is a test for the error class UNSUPPORTED_FEATURE: https://github.com/apache/spark/blob/34e3029a43d2a8241f70f2343be8285cb7f231b9/sql/core/src/test/scala/org/apache/spark/sql/errors/QueryCompilationErrorsSuite.scala#L151-L170

The test must have a check of:

1. the entire error message
2. sqlState if it is defined in the error-classes.json file
3. the error class

Issue Links

• is a clone of: SPARK-38749 Test the error class: RENAME_SRC_PATH_NOT_FOUND
• is cloned by: SPARK-38751 Test the error class: UNRECOGNIZED_SQL_TYPE
• links to: [Github] Pull Request #36209 (panbingkun)
• links to: [Github] Pull Request #36227 (MaxGekk)
• links to: [Github] Pull Request #36284 (panbingkun)