babelfish-for-postgresql / babelfish_extensions / 13996457128

74%

BABEL_5_X_DEV: 77%

push

github

Fixed case expression when one of the branch is NUMERIC and other is of EXACT NUMERIC. (#3607)

Earlier, CASE statement doesn't gives correct typmod when one of the branch is numeric and other is of exact numeric. The precision is being set 5 and scale is set to 4 in babelfish.
So expected result (123.0000) won't fit in Numeric(5,4). So we need to figure out correct precision and scale in this case.

To fix this in tsql_select_common_typmod hook, allowed exact numeric types for calculating correct precision and scale.

Task: BABEL-5678
Authored-by: yashneet vinayak yashneet@amazon.com
Signed-off-by: yashneet vinayak yashneet@amazon.com

28 of 28 new or added lines in 4 files covered. (100.0%)

43592 of 58968 relevant lines covered (73.92%)

145479.24 hits per line