LP#1773832: Empty deleted records can be surfaced in search results
There are cases where we avoid checking the deleted flag of bibs as an
optimization that avoids a JOIN in the search query. However, for some
shapes of real-world data, particularly in upgraded instances, deleted
records can slip through. This commit adds an explicit check for the
flag to all search queries.
Signed-off-by: Mike Rylander <email address hidden>
Signed-off-by: Daniel Pearl <email address hidden>
Signed-off-by: Jason Stephenson <email address hidden>
Added an index to action.usr_circ_history for much needed postgresql justice.
This will increase the speed when deleting patrons with large number of circulations.
Signed-off-by: blake <email address hidden>
Signed-off-by: Jason Boyer <email address hidden>
Signed-off-by: Jason Stephenson <email address hidden>