[SPARK-47700] Fix formatting of error messages with treeNode

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Jack Chen
• Reporter: Jack Chen
• Created: 02/Apr/24 20:22
• Updated: 03/Apr/24 23:40
• Resolved: 03/Apr/24 23:40

Description

Example: We are concatenating the plan without any separation: `in this locationFilter (dept_id#652`. We should add a colon and space or newline in between:

[UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY.ACCESSING_OUTER_QUERY_COLUMN_IS_NOT_ALLOWED] Unsupported subquery expression: Accessing outer query column is not allowed in this locationFilter (dept_id#652 = outer(dept_id#646))
+- SubqueryAlias dept
   +- View (`DEPT`, [dept_id#652, dept_name#653, state#654])
      +- Project [cast(dept_id#655 as int) AS dept_id#652, cast(dept_name#656 as string) AS dept_name#653, cast(state#657 as string) AS state#654]
         +- Project [dept_id#655, dept_name#656, state#657]
            +- SubqueryAlias DEPT
               +- LocalRelation [dept_id#655, dept_name#656, state#657]
. SQLSTATE: 0A000 

Issue Links

• links to: GitHub Pull Request #45825