17672990813
76%
BABEL_5_X_DEV: 77%

Ran 12 Sep 2025 11:44AM UTC

Jobs 1

Files 120

Run time 1min

Badge

Embed ▾

Committed 12 Sep 2025 11:20AM UTC coverage: 75.982%. Remained the same

Build # 17672990813

Build Type

push

github

Committed by

web-flow

Commit Message

Fix mathematical functions for Money and smallmoney (#4071)

* 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

49834 of 65587 relevant lines covered (75.98%)

382552.29 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	17672990813.1	12 Sep 2025 11:44AM UTC	120	75.98	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 17672990813
76%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 17672990813

babelfish-for-postgresql / babelfish_extensions / 17672990813 76% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 17672990813

babelfish-for-postgresql / babelfish_extensions / 17672990813
76%
BABEL_5_X_DEV: 77%

README BADGES
x