12632920102
76%
BABEL_5_X_DEV: 77%

Ran 06 Jan 2025 01:20PM UTC

Jobs 1

Files 115

Run time 2min

Badge

Embed ▾

Committed 06 Jan 2025 12:57PM UTC coverage: 74.879%. Remained the same

Build # 12632920102

Build Type

push

github

Committed by

web-flow

Commit Message

Fix inconsistent formatting issue in convert function when converting from money to varchar (#3337) (#3360)

Description
Currently when converting from money to varchar using convert function with different style values, the result is inconsistent with the formatting. This PR will address this issue by updating the logic to handle these edge cases. The issues that will get addressed in this PR are as follows

Extra space is getting added in the beginning of the result when style parameter is 0 or 2.
When input is 0, then 0 is missing before decimal in the result for style 0 and 2. Also for style 1 the result has $ before decimal instead of 0. For example, when converting value 0 with money datatype to varchar datatype
For style 0, result is  .00
For style 1, result is $.00
For style 2, result is  .0000
When style is 2, and the input has more than 2 digits after decimal, then the result is getting rounded upto 2 digits after decimal, which ideally should be rounded upto 4 digits.

Issues Resolved
BABEL-5462

Authored-by: Rohit Bhagat rohitbgt@amazon.com
Signed-off-by: Rohit Bhagat rohitbgt@amazon.com

Run Details

46736 of 62415 relevant lines covered (74.88%)

166341.43 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	12632920102.1	06 Jan 2025 01:20PM UTC	115	74.88	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 12632920102
76%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12632920102

babelfish-for-postgresql / babelfish_extensions / 12632920102 76% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12632920102

babelfish-for-postgresql / babelfish_extensions / 12632920102
76%
BABEL_5_X_DEV: 77%

README BADGES
x