[ https://issues.apache.org/jira/browse/FLINK-24691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17435808#comment-17435808 ]
Martijn Visser commented on FLINK-24691: ---------------------------------------- [~matriv] Do you have any thoughts on this one? > FLINK SQL SUM() causes a precision error > ---------------------------------------- > > Key: FLINK-24691 > URL: https://issues.apache.org/jira/browse/FLINK-24691 > Project: Flink > Issue Type: Bug > Components: Table SQL / Runtime > Affects Versions: 1.14.0 > Environment: flink release-1.14.0 > Reporter: Zongwen Li > Priority: Major > > code: > {code:java} > tableEnv.executeSql("select sum(cast( 1.03520274 as decimal(32, 8))) as num > ").print(); > {code} > expected: > 1.03520274 > actual: > 1.03520270 > > This function is normal in version 1.13.x. > Because I am not familiar with the SQL API source code, I did not find the > root error code. > -- This message was sent by Atlassian Jira (v8.3.4#803005)