[FLINK-20471] flink1.10SQL Precision overflow return null when using decimal

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 1.10.1
• Component/s: Table SQL / Runtime
• Labels: auto-deprioritized-major
• Assignee: Unassigned
• Reporter: sadfdddd
• Created: 03/Dec/20 13:59
• Updated: 11/May/21 11:00
• Resolved: 11/May/21 11:00

Description

flink1.10SQL Precision overflow return null when using decimal

this is my code

The calculation result is null

Dubug discovery

in codegen code this method is called

in this method

will get a 39 precision decimal result,  

So null is returned

My idea of modification is to cut the precision here or provide the configuration entry of precision

Maybe you can consider assigning it to me to fix it

 

Issue Links

• is duplicated by: FLINK-22586 Improve precision derivation for decimal arithmetics
• relates to: FLINK-22586 Improve precision derivation for decimal arithmetics