1
74%
BABEL_5_X_DEV: 77%

Ran 26 Apr 2024 02:34PM UTC

Files 114

Run time 5s

Badge

Embed ▾

Committed 26 Apr 2024 01:48PM UTC coverage: 72.984% (+0.04%) from 72.943%

Job # 8849316228.1

Build Type

push

github

Committed by

web-flow

Commit Message

Support LIKE operator for AI collations (Latin characters) (#2500)

This PR supports the LIKE operator for Accent Insensitive collations based on Latin (All the collations ending *CS_AI
and *CI_AI which are also known as non-deterministic collations). The native Postgres does not support LIKE operator for non-deterministic collations, so we have made some changes in the Babelfish extensions side to parse the incoming
node. We will try to identify the left and right node of LIKE operator and process them with the help of
remove_accents_internal function using following transformation. (This remove_accents_internal nothing but will
remove accents from input string.)

pattern LIKE text COLLATE CI_AI
<->
remove_accents_internal(pattern) as u_p LIKE remove_accents_internal(text) as u_t COLLATE CI_AS
<->
(u_p ILIKE u_t COLLATE CS_AS) AND
(u_t BETWEEN unaccent(pattern_const) AND (unaccent(pattern_const) || 0xffff)) COLLATE CS_AS)

If we have not handled any kind of node explicitly, then we will throw error. The remove_accents_internal take help of
ICU provided APIs to obtain unaccented version of input string with transformation rule.

TASK : BABEL-4791
Authored-by: Shameem Ahmed shmeeh@amazon.com
Co-Authored-by: Dipesh Dhameliya dddhamel@amazon.com
Signed-off-by: Shameem Ahmed shmeeh@amazon.com

Run Details

41287 of 56570 relevant lines covered (72.98%)

65023.63 hits per line

babelfish-for-postgresql / babelfish_extensions / 8849316228 / 1
74%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 8849316228.1

babelfish-for-postgresql / babelfish_extensions / 8849316228 / 1 74% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 8849316228.1

babelfish-for-postgresql / babelfish_extensions / 8849316228 / 1
74%
BABEL_5_X_DEV: 77%

README BADGES
x