[FLINK-22182] Incorrect round when dividing decimals

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.12.2
• Component/s: Table SQL / Runtime
• Assignee: Unassigned
• Reporter: Maciej Bryński
• Created: 09/Apr/21 13:44
• Updated: 11/May/21 11:04
• Resolved: 11/May/21 11:04

Description

Hi,

I have following problem:
This query:

select ((CAST(28604 as decimal(38,4)))/(cast(451 as decimal(38,4))) - 1121)/10 ;

Gives following answer:

-105.757650000000000000

Correct answer should be:

-105,75764966740576496674057649667

Why the result is rounded to 5th decimal place ?

Saving both values back to Decimal(38,4) column will give different results: -105.7577 vs -105.7576 (where second one is correct)

Issue Links

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