Extremely "empty" records hide from searches

Bug #1472299 reported by Mike Rylander on 2015-07-07
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Evergreen
Undecided
Unassigned

Bug Description

When a record has no usable fixed field data, as can be the case with very "thin" on-order records from some vendors, the stock record attribute configuration will produce an empty set for the mapped array of attribute value IDs. When the array is empty, we don't insert it into the appropriate filter-related table as there's nothing to filter on. This is a problem because that table performs double duty as a fast-path existence check stand-in for the wider full-record table.

We need to either go ahead and insert the empty array into the attribute filter table, or include a stock attribute definition that will always exist in Evergreen bib records. For the latter, the simplest workaround is:

-- Every EG bib will have 'biblio' in this field
insert into config.record_attr_definition
  (name,label,filter,sorter,multi,tag,sf_list)
  values ('eg_rtype','EG Record Type',true,false,false,'901','t');

-- Wastes one array position (4 bytes) in each attr array
select metabib.reingest_record_attributes(id)
  from biblio.record_entry
  where not deleted
    and not exists (
      select source from metabib.record_attr_vector_list where source = id
);

Changed in evergreen:
milestone: none → 2.9-alpha
description: updated
Changed in evergreen:
milestone: 2.9-alpha → 2.9-beta
Changed in evergreen:
milestone: 2.9-beta → 2.9.0
Michele Morgan (mmorgan) on 2015-09-03
summary: - Extremely "emtpy" records hide from searches
+ Extremely "empty" records hide from searches
Jason Stephenson (jstephenson) wrote :

Removing milestones pending addition of a branch and pullrequest tag.

Changed in evergreen:
milestone: 2.9.0 → none
no longer affects: evergreen/2.7
Andrea Neiman (aneiman) on 2018-01-19
no longer affects: evergreen/2.8
tags: added: search
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers