1
76%
BABEL_5_X_DEV: 77%

Ran 16 May 2025 04:55AM UTC

Files 119

Run time 4s

Badge

Embed ▾

Committed 16 May 2025 04:21AM UTC coverage: 75.265% (+0.01%) from 75.255%

Job # 15060577099.1

Build Type

push

github

Committed by

web-flow

Commit Message

Reimplement ISNUMERIC() function in C language to improve performance (#3765)

To improve the performance of queries with ISNUMERIC() predicates, this commit
reimplements the ISNUMERIC() function from PL/pgSQL to C language. The new implementation
uses InputFunctionCallSafe for safer and more efficient type checking and conversion.

Additionally, the money data type's input function has been updated to report
invalid input as a "soft" error for InputFunctionCallSafe, avoiding unnecessary transaction aborts.
This commit also changes the ISNUMERIC() function attributes to IMMUTABLE and
PARALLEL SAFE for better query optimisation opportunities.

Task : BABEL-5696
Signed-off-by: Sumit Jaiswal <sumiji@amazon.com>

Run Details

48372 of 64269 relevant lines covered (75.26%)

307050.36 hits per line

babelfish-for-postgresql / babelfish_extensions / 15060577099 / 1
76%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 15060577099.1

babelfish-for-postgresql / babelfish_extensions / 15060577099 / 1 76% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 15060577099.1

babelfish-for-postgresql / babelfish_extensions / 15060577099 / 1
76%
BABEL_5_X_DEV: 77%

README BADGES
x