[
https://issues.apache.org/jira/browse/FLINK-34376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17814583#comment-17814583
]
Fangliang Liu edited comment on FLINK-34376 at 2/6/24 3:24 AM:
---------------------------------------------------------------
Hi [~matriv], [~twalthr], [~zonli]
Related issues:
https://issues.apache.org/jira/browse/FLINK-24691
was (Author: liufangliang):
Hi [~matriv] ,[~twalthr] , [~zonli]
Related issues:
https://issues.apache.org/jira/browse/FLINK-24691
> FLINK SQL SUM() causes a precision error
> ----------------------------------------
>
> Key: FLINK-34376
> URL: https://issues.apache.org/jira/browse/FLINK-34376
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Runtime
> Affects Versions: 1.14.3, 1.18.1
> Reporter: Fangliang Liu
> Priority: Major
> Attachments: image-2024-02-06-11-15-02-669.png,
> image-2024-02-06-11-17-03-399.png
>
>
> {code:java}
> select cast(sum(CAST(9.000000000000000011 AS DECIMAL(38,18)) *10 ) as STRING)
> {code}
> The precision is wrong in the Flink 1.14.3 and master branch
> !image-2024-02-06-11-15-02-669.png!
>
> The accuracy is correct in the Flink 1.13.2
> !image-2024-02-06-11-17-03-399.png!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
