1
76%
BABEL_5_X_DEV: 77%

Ran 19 Jun 2025 06:24AM UTC

Files 119

Run time 8s

Badge

Embed ▾

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

Job # 15750572467.1

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

Run Details

48719 of 64503 relevant lines covered (75.53%)

325139.2 hits per line

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

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 15750572467.1

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

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 15750572467.1

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

README BADGES
x