babelfish-for-postgresql / babelfish_extensions / 14972397541

75%

BABEL_6_X_DEV: 78%

push

github

Adjust precision and scale in Numeric Multiplication and Division (#3729) (#3742)

In Babelfish's implementation of numeric operations (multiplication and division), logic for adjustment of precision and scale is incorrect as compared to TSQL.
Changes made to fix the issues:
* The numeric operations (multiplication and division) logic for precision and scale adjustment is corrected as per TSQL documentation.
* Fixed the API tsql_numeric_get_typmod and tds_numeric_get_typmod to give correct typmod for a numeric value.
* Added handling for UDT's and fixed length datatypes in T_var node in resolve_numeric_typmod_from_exp

Issues Resolved
Task: BABEL-5689

Signed-off-by: yashneet vinayak <yashneet@amazon.com>
Co-authored-by: yashneet vinayak <yashneet@amazon.com>

379 of 410 new or added lines in 8 files covered. (92.44%)

47723 of 63789 relevant lines covered (74.81%)

252074.83 hits per line