Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Missing f_unaccent for compound fields full text index

Description

Identified during bugfest testing. A simple inventory search generated query asking for this index:

(to_tsvector('simple'::regconfig, f_unaccent(concat_space_sql(VARIADIC ARRAY[jsonb ->> 'title'::text, concat_array_object_values(jsonb -> 'contributors'::text, 'name'::text), concat_array_object_values(jsonb -> 'identifiers'::text, 'value'::text)]))))

but we have this one in database:

(to_tsvector('simple'::regconfig, concat_space_sql(VARIADIC ARRAY[jsonb ->> 'title'::text, concat_array_object_values(jsonb -> 'contributors'::text, 'name'::text), concat_array_object_values(jsonb -> 'identifiers'::text, 'value'::text)])))

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:

Jakub Skoczen December 17, 2019 at 2:38 PM

Re-opening as a bug was discovered in the implementation merged to master.

Jakub Skoczen December 13, 2019 at 9:52 AM

This looks like a regression due to https://folio-org.atlassian.net/browse/MODINVSTOR-349#icft=MODINVSTOR-349, correct?

Done

Details

Assignee

Reporter

Labels

Priority

Story Points

Sprint

Development Team

Core: Platform

Fix versions

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created December 12, 2019 at 7:30 PM
Updated January 6, 2020 at 2:30 PM
Resolved December 18, 2019 at 10:48 AM
TestRail: Cases
TestRail: Runs

Flag notifications