[FLINK-24809] Check & possible fix decimal precision and scale for all Aggregate functions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Release Note: This changes the result of a decimal SUM with retraction and AVG() between 1.14.0 and 1.14.1. It restores part of behavior back to 1.13 to be consistent with Hive/Spark.
• Assignee: Marios Trivyzas
• Reporter: Marios Trivyzas
• Created: 06/Nov/21 10:15
• Updated: 29/Apr/22 09:52
• Resolved: 30/Dec/21 08:16

Description

Similar to FLINK-24691, check the behaviour of the rest of Aggregate functions like Sum0AggFunction, AvgAggFunction, etc. regarding the precision/scale of the resulting decimal.

Issue Links

• relates to: FLINK-24691 FLINK SQL SUM() causes a precision error
• links to: GitHub Pull Request #18135