[SPARK-34012] Keep behavior consistent when conf `spark.sql.legacy.parser.havingWithoutGroupByAsWhere` is true with migration guide

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.8, 3.0.2, 3.1.0, 3.2.0
• Fix Version/s: 2.4.8, 3.0.2, 3.1.1, 3.2.0
• Component/s: SQL
• Assignee: angerszhu
• Reporter: angerszhu
• Created: 05/Jan/21 12:11
• Updated: 12/Dec/22 18:10
• Resolved: 05/Jan/21 23:56

Description

According to https://github.com/apache/spark/pull/29087#issuecomment-754389257

fix bug and add UT

Issue Links

• relates to: SPARK-31519 Cast in having aggregate expressions returns the wrong result
• relates to: SPARK-25708 HAVING without GROUP BY means global aggregate
• links to: [Github] Pull Request #31039 (AngersZhuuuu)
• links to: [Github] Pull Request #31049 (AngersZhuuuu)
• links to: [Github] Pull Request #31050 (AngersZhuuuu)
• links to: [Github] Pull Request #31050 (AngersZhuuuu)