[SPARK-39315] Refactor PromotePrecision and CheckOverflow with decimal binary arithmetic

• Type: Umbrella
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.4.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: XiDuo You
• Created: 27/May/22 08:21
• Updated: 27/May/22 08:21

Description

For a decimal binary arithmetic expression, we correct its runtime data type and result data type at DecimalPrecision. It has two drawback:

1. it has some bug with the different ordering of the rules in TypeCoercion
2. it's unnecessary to change its runtime data type for decimal, as it supports eval with different precision. So what we need to do is change the result type precision.

 

Sub-Tasks

• Merge PromotePrecision and CheckOverflow into decimal binary arithmetic: Resolved
• Add DecimalDivideWithOverflowCheck for decimal average: Resolved