babelfish-for-postgresql / babelfish_extensions / 12742860948

77%

push

github

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

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>

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

46978 of 62673 relevant lines covered (74.96%)

167757.04 hits per line