[SPARK-38725] Test the error class: DUPLICATE_KEY

• 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: BingKun Pan
• Reporter: Max Gekk
• Shepherd: Max Gekk
• Created: 31/Mar/22 17:00
• Updated: 14/Apr/22 06:42
• Resolved: 14/Apr/22 06:42

Description

Add at least one test for the error class DUPLICATE_KEY to QueryParsingErrorsSuite. The test should cover the exception throw in QueryParsingErrors:

  def duplicateKeysError(key: String, ctx: ParserRuleContext): Throwable = {
    // Found duplicate keys '$key'
    new ParseException(errorClass = "DUPLICATE_KEY", messageParameters = Array(key), ctx)
  }

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-38724 Test the error class: DIVIDE_BY_ZERO
• is cloned by: SPARK-38727 Test the error class: FAILED_EXECUTE_UDF
• links to: [Github] Pull Request #36160 (panbingkun)
• links to: [Github] Pull Request #36160 (panbingkun)
• links to: [Github] Pull Request #36188 (panbingkun)
• links to: [Github] Pull Request #36188 (panbingkun)