LP#1773832: Empty deleted records can be surfaced in search results user/miker/lp-1773832-hide-deleted-bibs
authorMike Rylander <mrylander@gmail.com>
Wed, 20 Jun 2018 13:22:38 +0000 (09:22 -0400)
committerMike Rylander <mrylander@gmail.com>
Wed, 20 Jun 2018 13:22:38 +0000 (09:22 -0400)
commitb9f13347645658ff5c622c20abccd0e75a6406a8
tree1503d63c05d83be52af548ed91ef267fa53d960c
parent1dc4c5fda3dcedc5c2d401e4d45084c070bf9e4e
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 <mrylander@gmail.com>
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm