You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "sadfdddd (Jira)" <ji...@apache.org> on 2020/12/03 14:00:00 UTC

[jira] [Created] (FLINK-20471) flink1.10SQL中decimal精度溢出返回null的问题

sadfdddd created FLINK-20471:
--------------------------------

             Summary: flink1.10SQL中decimal精度溢出返回null的问题
                 Key: FLINK-20471
                 URL: https://issues.apache.org/jira/browse/FLINK-20471
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / API, Table SQL / Runtime
    Affects Versions: 1.10.1
            Reporter: sadfdddd
         Attachments: image-2020-12-03-21-47-31-755.png, image-2020-12-03-21-48-44-901.png, image-2020-12-03-21-49-40-529.png, image-2020-12-03-21-50-11-117.png

h2. *在使用flink1.10sql发现decimal精度溢出返回null的问题*

这是我的代码

!image-2020-12-03-21-47-31-755.png|width=835,height=435!

!image-2020-12-03-21-48-44-901.png!

计算结果为null

{color:#de350b}定位源码发现{color}

{color:#de350b}codegen的代码中调用了{color}

!image-2020-12-03-21-49-40-529.png!

{color:#de350b}其中这个方法{color}

!image-2020-12-03-21-50-11-117.png!

会出现得到一个39位的溢出就会直接返回null,导致计算结果错误为null

我的思路是在此截断精度,或者能提供精度的配置入口

可以考虑指派给我修复这个问题

 



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