Attempting to validate an empty field causes scan of most/all of authority.record_entry
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned | ||
3.1 |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Clicking the "Validate" button in the MARC editor when an authority-
SELECT "are".id AS "id" FROM authority.
This is at best inefficient, as it can cause a sequential scan of authority.
I have reproduced the problem in the web staff client's MARC editor and suspect it also affects the XUL MARC editor.
Evergreen master
Changed in evergreen: | |
milestone: | 3.0.4 → 3.05 |
tags: | added: pullrequest |
Changed in evergreen: | |
milestone: | 3.0.5 → 3.0.6 |
Changed in evergreen: | |
milestone: | 3.0.6 → 3.0.7 |
Changed in evergreen: | |
milestone: | 3.0.7 → 3.0.8 |
Changed in evergreen: | |
milestone: | 3.0.8 → 3.0.9 |
Changed in evergreen: | |
milestone: | 3.0.9 → 3.0.10 |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
A patch is available at the tip of the user/gmcharlt/ lp1745462_ we_will_ not_bow_ to_all_ the_authorities branch:
http:// git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ gmcharlt/ lp1745462_ we_will_ not_bow_ to_all_ the_authorities