amazon-aurora / babelfish_extensions / 12795535349

75%

main: 77%

push

github

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

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%)

46951 of 62656 relevant lines covered (74.93%)

165925.55 hits per line