15750572467
76%
BABEL_6_X_DEV: 78%

Ran 19 Jun 2025 06:24AM UTC

Jobs 1

Files 119

Run time 1min

Badge

Embed ▾

Committed 19 Jun 2025 05:51AM UTC coverage: 75.53% (+0.009%) from 75.521%

Build # 15750572467

Build Type

push

github

Committed by

web-flow

Commit Message

fix for incorrect behaviour of patindex function (#3825) (#3849)

The problem is with the PATINDEX function's behavior when searching for a suffix pattern (pattern at the end of a string).

SELECT PATINDEX('%ing', 'This is a testing string') AS EndPattern

Current behavior:
It returns 15 (matching 'testing'). This is incorrect because we're looking for a suffix match

Expected behavior:
It should return 22 (matching 'string'), because '%ing' should match 'ing' at the end of the string

When we use '%ing' as a pattern, it should specifically match 'ing' when it appears at the end of the string
Instead, it's matching the first occurrence of 'ing' anywhere in the string

Another problem is that when we do a wildcard match i.e when the pattern is '%', function should return the output 1 as in a wildcard match first character will be matched. Current behaviour gives 0 as worng output, fixed that behaviour.

Task: BABEL-5817

Signed-off-by: Pranav Jain pranavjc@amazon.com

Coverage Stats

48719 of 64503 relevant lines covered (75.53%)

325139.2 hits per line

Coverage Regressions

Lines	Coverage	∆	File
2	74.67	0.43%	contrib/babelfishpg_tsql/src/collation.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	15750572467.1	19 Jun 2025 06:24AM UTC	119	75.53	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 15750572467
76%
BABEL_6_X_DEV: 78%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 15750572467

babelfish-for-postgresql / babelfish_extensions / 15750572467 76% BABEL_6_X_DEV: 78%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 15750572467

babelfish-for-postgresql / babelfish_extensions / 15750572467
76%
BABEL_6_X_DEV: 78%

README BADGES
x