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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.14.3, 1.15.0
• Component/s: Table SQL / Runtime
• Labels: pull-request-available starter
• Assignee: Yao Zhang
• Reporter: Caizhi Weng
• Created: 04/Aug/21 07:08
• Updated: 15/Dec/21 01:44
• Resolved: 07/Sep/21 09:13

Description

Run the following 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)

The result is

123.450
123.000
100.000
123.45
123.0
100.0

It seems that the resulting scale of TRUNCATE(DECIMAL, ...) is the same as that of the input decimal.

Issue Links

• links to: GitHub Pull Request #16740