20478207056
77%

Ran 24 Dec 2025 04:51AM UTC

Jobs 1

Files 121

Run time 78min

Badge

Embed ▾

Committed 24 Dec 2025 04:26AM UTC coverage: 76.864%. Remained the same

Build # 20478207056

Build Type

push

github

Committed by

web-flow

Commit Message

Fix inconsistent index scans for binary/varbinary comparison operators and add cross-type support (#4246)

Query planner often chose sequential scans over index scans even for highly selective binary/varbinary queries due to missing operator optimization information which left the planner without accurate selectivity estimates. We added operator optimization information (RESTRICT, NEGATOR, JOIN) to comparison operators which provides better selectivity estimates helping the optimizer choose appropriate scans.
Additionally, index scans were not possible on comparison operators with different binary operand types (binary and varbinary combinations) as implicit casts were applied to the indexed column preventing index usage. Added explicit cross-type operators in the operator family enabling direct comparisons without column transformation, allowing index scans.

Task: BABEL-6098
Signed-off-by: Rucha Kulkarni <ruchask@amazon.com>

Run Details

52482 of 68279 relevant lines covered (76.86%)

385727.83 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	20478207056.1	24 Dec 2025 04:51AM UTC	121	76.86	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 20478207056
77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 20478207056

babelfish-for-postgresql / babelfish_extensions / 20478207056 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 20478207056

babelfish-for-postgresql / babelfish_extensions / 20478207056
77%

README BADGES
x