• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

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

Build:
Build:
LAST BUILD BRANCH: BABEL_4_X_DEV
DEFAULT BRANCH: BABEL_5_X_DEV
Ran 22 May 2025 05:26AM UTC
Jobs 1
Files 119
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

22 May 2025 04:52AM UTC coverage: 75.293% (+0.01%) from 75.28%
15178427729

push

github

web-flow
Use Index Scan for EXACT and PREFIX pattern matches for LIKE for Const node inside CollateExpr (#3770)

With this commit: e119968, babelfish now use Index Scans for the following cases:

-- CASE 1
SELECT COL FROM TAB WHERE COL LIKE 'ab'

-- CASE 2
SELECT COL FROM TAB WHERE COL LIKE 'a%'

However if there is a Collate clause with the right operand :

-- CASE 1
SELECT COL FROM TAB WHERE COL LIKE 'ab' COLLATE DATABASE_DEFAULT

-- CASE 2
SELECT COL FROM TAB WHERE COL LIKE 'a%' COLLATE DATABASE_DEFAULT

then Babelfish does NOT use Index Scan.

This commit enables Index scan for such cases. We do this by removing CollateExpr on both operands as those are
redundant and the OpExpr (LIKE) operator is already aware of the collation it needs to use.

Task: BABEL-5077
Signed-off-by: Shameem Ahmed <shmeeh@amazon.com>

31 of 34 new or added lines in 1 file covered. (91.18%)

48411 of 64297 relevant lines covered (75.29%)

317595.04 hits per line

New Missed Lines in Diff

Lines Coverage ∆ File
3
74.08
0.54% contrib/babelfishpg_tsql/src/collation.c
Jobs
ID Job ID Ran Files Coverage
1 15178427729.1 22 May 2025 05:26AM UTC 119
75.29
GitHub Action Run
Source Files on build 15178427729
  • Tree
  • List 119
  • Changed 3
  • Source Changed 1
  • Coverage Changed 3
Coverage ∆ File Lines Relevant Covered Missed Hits/Line
  • Back to Repo
  • Github Actions Build #15178427729
  • 431bf0be on github
  • Prev Build on BABEL_4_X_DEV (#15065162691)
  • Next Build on BABEL_4_X_DEV (#15208246028)
  • Delete
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc