babelfish-for-postgresql / babelfish_extensions / 12797160734

74%

BABEL_5_X_DEV: 77%

push

github

Implement modulo operator for MONEY/SMALLMONEY types (#3408)

Description
-----------
Due to the missing modulo operator for MONEY/SMALLMONEY types, it will choose
the other Postgres internal alternatives like int4mod and numeric_mod, which will
involve additional implicit CASTing between MONEY/SMALLMONEY types and other types.
These CASTings could cause loss of precision and wrong results. What's more, the result
of calculation won't be MONEY/SMALLMONEY types any more.

Fix
---
Implement the modulo function and operator for MONEY/SMALLMONEY types. The reason why we don't
need to implement the functions between MONEY/SMALLMONEY types and interger types is that it
will choose the MONEY-MONEY/SMALLMONEY-SMALLMONEY functions to calculate. And the result type is
expected.

Task: BABEL-5480
Signed-off-by: Bo Li <zboli@amazon.com>

8 of 9 new or added lines in 1 file covered. (88.89%)

43329 of 58683 relevant lines covered (73.84%)

146104.92 hits per line