Caizhi Weng created FLINK-23614:
-----------------------------------
Summary: 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: Improvement
Components: Table SQL / Runtime
Affects Versions: 1.14.0
Reporter: Caizhi Weng
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)
