[SPARK-43487] Wrong error message used for `ambiguousRelationAliasNameInNestedCTEError`

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.5.0
• Component/s: Spark Core
• Assignee: Johan Lasperas
• Reporter: Johan Lasperas
• Created: 12/May/23 13:51
• Updated: 22/May/23 20:45
• Resolved: 22/May/23 20:45

Description

The batch of errors migrated to error classes as part of spark-40540 contains an error that got mixed up with the wrong error message:

ambiguousRelationAliasNameInNestedCTEError uses the same error message as the following commandUnsupportedInV2TableError:

 

WITH t AS (SELECT 1), t2 AS ( WITH t AS (SELECT 2) SELECT * FROM t) SELECT * FROM t2;
AnalysisException: t is not supported for v2 tables

The error should be:

AnalysisException: Name tis ambiguous in nested CTE.
Please set spark.sql.legacy.ctePrecedencePolicy to CORRECTED so that name defined in inner CTE takes precedence. If set it to LEGACY, outer CTE definitions will take precedence. See more details in SPARK-28228.

Issue Links

• links to: [Github] Pull Request #41155 (johanl-db)
• links to: [Github] Pull Request #41161 (panbingkun)
• links to: [Github] Pull Request #41161 (panbingkun)