You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "Zongwen Li (Jira)" <ji...@apache.org> on 2021/10/29 06:42:00 UTC

[jira] [Created] (FLINK-24691) FLINK SQL SUM() causes a precision error

Zongwen Li created FLINK-24691:
----------------------------------

             Summary: 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


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.

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)