[SPARK-35987] The ANSI flags of Sum and Avg should be kept after being copied

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.0, 3.3.0
• Component/s: SQL
• Assignee: Gengliang Wang
• Reporter: Gengliang Wang
• Created: 02/Jul/21 09:00
• Updated: 05/Jul/21 04:35
• Resolved: 05/Jul/21 04:35

Description

For Views and UDFs, it is important to show consistent results even the ANSI configuration is different in the running session. This is why many expressions like 'Add'/'Divide'/'CAST' making the ANSI flag part of its case class parameter list.
We should make it consistent for `Sum`/`Avg`

Issue Links

• links to: [Github] Pull Request #33186 (gengliangwang)
• links to: [Github] Pull Request #33186 (gengliangwang)