[SPARK-37932] Analyzer can fail when join left side and right side are the same view

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.3.0, 3.2.2
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Zhixiong Chen
• Reporter: Feng Zhu
• Created: 17/Jan/22 10:49
• Updated: 07/Mar/24 17:46
• Resolved: 01/Mar/22 17:25

Description

See the attachment for details, including SQL and the exception information.

• sql1, there is a normal filter (LO_SUPPKEY > 10) in the right side subquery, Analyzer works as expected;
• sql2, there is a HAVING filter(HAVING COUNT(DISTINCT LO_SUPPKEY) > 1) in the right side subquery, Analyzer failed with "Resolved attribute(s) LO_SUPPKEY#337 missing ...".

      From the debug info, the problem seems to be occurred after the rule DeduplicateRelations is applied.

Issue Links

• links to: [Github] Pull Request #35361 (chenzhx)
• links to: [Github] Pull Request #35649 (chenzhx)
• links to: [Github] Pull Request #35649 (chenzhx)
• links to: [Github] Pull Request #35660 (chenzhx)
• links to: [Github] Pull Request #35684 (chenzhx)
• links to: [Github] Pull Request #35684 (chenzhx)
• links to: GitHub Pull Request #35684