contributor search returns no results when name contains "-"

Description

Following should return result but it does not.

Reason:

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

1

Checklist

hide

TestRail: Results

Activity

Show:

Julian Ladisch August 10, 2019 at 1:34 PM

Adam asked on https://github.com/folio-org/raml-module-builder/pull/489:

I hope that the replace-stuff will not hinder indexes from being used.

This shows that the index t_to_tsvector_idx is used because the replace is on the right hand side of @@ only. This is similar to jsonb->>'title' LIKE f_unaccent('abc xyz').

Jakub Skoczen August 9, 2019 at 12:14 PM

Asked to review so we can merge before the end of the sprint.

Julian Ladisch August 8, 2019 at 5:36 PM

Postponed to q3.2-2019 as requested by Jakub.

Julian Ladisch August 6, 2019 at 1:52 PM

This also works for UUID matching:

Julian Ladisch July 31, 2019 at 7:13 PM
Edited

My implementation idea is this:

Replace space by <-> and replace special characters (& <-> :) by other punctuation.
Pass it through to_tsquery.
Replace any & by <->.

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Core: Platform

Fix versions

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created July 11, 2019 at 5:49 PM
Updated January 3, 2020 at 2:27 PM
Resolved August 12, 2019 at 12:07 PM
TestRail: Cases
TestRail: Runs