[jira] [Commented] (FLINK-23614) The resulting scale of TRUNCATE(DECIMAL, ...) is not correct

["godfrey he (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-23614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17435744#comment-17435744 ] 

godfrey he commented on FLINK-23614:
------------------------------------

1.14.1: 8c7cbcd9744378dccb4b6ab0493c7d273c69dfef

> The resulting scale of TRUNCATE(DECIMAL, ...) is not correct
> ------------------------------------------------------------
>
>                 Key: FLINK-23614
>                 URL: https://issues.apache.org/jira/browse/FLINK-23614
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Runtime
>    Affects Versions: 1.14.0
>            Reporter: Caizhi Weng
>            Assignee: Yao Zhang
>            Priority: Major
>              Labels: pull-request-available, starter
>             Fix For: 1.15.0
>
>
> Run the following SQL
> {code:sql}
> SELECT
>   TRUNCATE(123.456, 2),
>   TRUNCATE(123.456, 0),
>   TRUNCATE(123.456, -2),
>   TRUNCATE(CAST(123.456 AS DOUBLE), 2),
>   TRUNCATE(CAST(123.456 AS DOUBLE), 0),
>   TRUNCATE(CAST(123.456 AS DOUBLE), -2)
> {code}
> The result is
> {code}
> 123.450
> 123.000
> 100.000
> 123.45
> 123.0
> 100.0
> {code}
> It seems that the resulting scale of {{TRUNCATE(DECIMAL, ...)}} is the same as that of the input decimal.



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