asset.copy_vis_attr_cache upgrade script includes deleted items
Bug #1731281 reported by
Jason Boyer
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Eg 3.0
With bug 1698206 we can drop staged search thanks due in part to the asset.copy_
The presence of an entry in this table can cause inaccurate "X of Y copies available at $location" in search results when copies were deleted before the upgrade script was run. This is especially annoying when *all* copies were deleted and users are looking for titles that don't exist.
Quick branch incoming.
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Branching out: git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ jboyer/ lp1731281- acvac-cleanup
http://
Testing: vis_attr_ cache for an item that has been deleted attached to a record that the owning library no longer holds any copies of. A search for that title at that library will return the record with no holdings and the message "1 of 1 available" (numbers depending on how many deleted copies from that ou were attached.)
make sure there's at least one entry in the asset.copy_
After running script, the record above will no longer appear in search results scoped to locations where all remaining copies were deleted.