15065162691
76%
BABEL_5_X_DEV: 77%

Ran 16 May 2025 09:55AM UTC

Jobs 1

Files 119

Run time 1min

Badge

Embed ▾

Committed 16 May 2025 09:21AM UTC coverage: 75.28% (+0.02%) from 75.265%

Build # 15065162691

Build Type

push

github

Committed by

web-flow

Commit Message

Add operator class between int and numeric to support index scan (#3764)

Earlier, index scan would not be chosen by the optimizer when filtering between
int and numeric types if the index was created on a numeric column. While index
scans worked when the index was on an integer column (due to existing operator
class as part of int operator family), the reverse case wasn't supported.

This commit fixes this issue by adding a new operator class as part of the numeric
operator family which allows the optimizer to utilize indexes on numeric columns when
filtering with integer values, improving query performance in these scenarios.

This changes also requires engine changes (babelfish-for-postgresql/postgresql_modified_for_babelfish#578)
in order to dump these Babelfish defined operator class correctly during pg_upgrade.

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

Run Details

48382 of 64269 relevant lines covered (75.28%)

312437.62 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
2	76.03	-0.63%	contrib/babelfishpg_tds/src/backend/tds/tdscomm.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	15065162691.1	16 May 2025 09:55AM UTC	119	75.28	GitHub Action Run

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

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 15065162691

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

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 15065162691

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

README BADGES
x