babelfish-for-postgresql / babelfish_extensions / 12763991277

74%

BABEL_6_X_DEV: 78%

Build Type

push

github

Committed by web-flow

Commit Message

Fix formatting issue in CAST MONEY to CHAR/VARCHAR (#3367) (#3393)

While CASTing money/smallmoney to (N)VARCHAR/(N)CHAR, the value get rounded
to 4 decimal places instead of 2. Fixed this by implementing CASTs from money to
CHAR/VARCHAR datatype which rounds off input money value to 2 decimal places and
converts it to string.

Additionally, while CASTing money values to (N)CHAR, the resultant string gets left padded
instead of usual right padding. This commit also fixes this issue.

Task: BABEL-5478
Signed-off-by: Rishabh Tanwar <ritanwar@amazon.com>

Coverage Stats

43 of 48 new or added lines in 2 files covered. (89.58%)

465 existing lines in 3 files now uncovered.

43319 of 58674 relevant lines covered (73.83%)

146121.99 hits per line