[SPARK-33131] Fix grouping sets with having clause can not resolve qualified col name

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.0, 2.4.1, 2.4.2, 2.4.3, 2.4.4, 2.4.5, 2.4.6, 2.4.7, 3.1.0
• Fix Version/s: 2.4.8, 3.0.2, 3.1.0
• Component/s: SQL
• Assignee: XiDuo You
• Reporter: XiDuo You
• Created: 13/Oct/20 11:18
• Updated: 18/Oct/20 07:24
• Resolved: 16/Oct/20 11:26

Description

Grouping sets construct new aggregate lost the qualified name of grouping expression. Here is a example:

-- Works resolved by ResolveReferences
select c1 from values (1) as t1(c1) group by grouping sets(t1.c1) having c1 = 1

-- Works because of the extra expression c1
select c1 as c2 from values (1) as t1(c1) group by grouping sets(t1.c1) having t1.c1 = 1

-- Failed
select c1 from values (1) as t1(c1) group by grouping sets(t1.c1) having t1.c1 = 1

Issue Links

• links to: [Github] Pull Request #30029 (ulysses-you)
• links to: [Github] Pull Request #30075 (ulysses-you)
• links to: [Github] Pull Request #30077 (ulysses-you)