[FLINK-24414] Casting a decimal to a String doesn't do left zero padding

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Marios Trivyzas
• Reporter: Marios Trivyzas
• Created: 30/Sep/21 09:05
• Updated: 08/Nov/21 11:16
• Resolved: 08/Nov/21 11:16

Description

CAST(a AS STRING) where a is a DECIMAL(5.3) with value 9.87 results in

9.870 so we only get right 0 padding to fill in the fractional digits.

 

Postgres and Oracle also don't do left zero padding.

Issue Links

• links to: GitHub Pull Request #17694