[SPARK-39098] Test the error class: PIVOT_VALUE_DATA_TYPE_MISMATCH

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 3.4.0
• Component/s: SQL
• Labels: pull-request-available starter
• Assignee: Unassigned
• Reporter: Max Gekk
• Shepherd: Max Gekk
• Created: 04/May/22 18:52
• Updated: 02/Aug/24 20:34
• Resolved: 29/Sep/22 06:04

Description

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

  def pivotValDataTypeMismatchError(pivotVal: Expression, pivotCol: Expression): Throwable = {
    new AnalysisException(
      errorClass = "PIVOT_VALUE_DATA_TYPE_MISMATCH",
      messageParameters = Array(
        pivotVal.toString, pivotVal.dataType.simpleString, pivotCol.dataType.catalogString))
  }

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

• duplicates: SPARK-38748 Test the error class: PIVOT_VALUE_DATA_TYPE_MISMATCH
• is a clone of: SPARK-38744 Test the pivot error classes
• links to: GitHub Pull Request #47591