[ https://issues.apache.org/jira/browse/FLINK-10438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17385414#comment-17385414 ]
Maciej Bryński commented on FLINK-10438: ---------------------------------------- [~pnowojski] I think this problem is still valid in 2021. I think we should change return types for following functions when using DECIMAL as argument. https://issues.apache.org/jira/browse/FLINK-23472 > Built in functions should document the returned types > ----------------------------------------------------- > > Key: FLINK-10438 > URL: https://issues.apache.org/jira/browse/FLINK-10438 > Project: Flink > Issue Type: Improvement > Components: Documentation, Table SQL / API > Affects Versions: 1.6.1 > Reporter: Piotr Nowojski > Priority: Minor > Labels: auto-deprioritized-major > > As it is now, user have no idea to know whether the result of the operation > is accurate or not. > For example {{POWER(4, 2)}} or {{POWER(2.5, )}} could return exact results > (with proper {{DECIMAL}} support), while it seems like now they are silently > returning approximated result (because of {{DOUBLE}} arithmetic). Same > applies to other arithmetic functions, like {{COS SIN ATAN LOG ...}}. > Such behaviour should be documented. In some cases documenting the argument > types also might be important. -- This message was sent by Atlassian Jira (v8.3.4#803005)