17574026078
77%

Ran 09 Sep 2025 07:14AM UTC

Jobs 1

Files 120

Run time 1min

Badge

Embed ▾

Committed 09 Sep 2025 06:37AM UTC coverage: 76.308%. Remained the same

Build # 17574026078

Build Type

push

github

Committed by

web-flow

Commit Message

Fix mathematical functions for Money and smallmoney (#4046)

This PR fixes datatype and precision mismatches in the following mathematical functions when used with MONEY/SMALLMONEY in Babelfish:

DEGREES() – Converts radians to degrees
RADIANS() – Converts degrees to radians

Behavior Differences Fixed :

    Return datatype mismatch. Babelfish returned float while TSQL returns money/smallmoney

    Precision difference. Babelfish used high-precision float values (e.g., 90.00021045914971) while TSQL rounded results based on datatype precision (e.g., 90.0002)

SELECT DEGREES(CAST(PI()/2 AS SMALLMONEY)) AS result;

With this change, Babelfish now returns results as money/smallmoney instead of float and applies rounding consistent with TSQL (4 decimal places for money, up to 4 for smallmoney).

Task: BABEL-5748

Signed-off-by: Harsh Dubey harshdu@amazon.com

Run Details

50421 of 66076 relevant lines covered (76.31%)

379983.69 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	17574026078.1	09 Sep 2025 07:14AM UTC	120	76.31	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 17574026078
77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 17574026078

babelfish-for-postgresql / babelfish_extensions / 17574026078 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 17574026078

babelfish-for-postgresql / babelfish_extensions / 17574026078
77%

README BADGES
x