LP#1482757: Remove 'orphaned_uri_list' and 'NOT cn.deleted' criteria
authorMichele Morgan <mmorgan@noblenet.org>
Fri, 24 Apr 2020 16:43:39 +0000 (12:43 -0400)
committerMichele Morgan <mmorgan@noblenet.org>
Fri, 24 Apr 2020 17:13:41 +0000 (13:13 -0400)
commit60b021cefd3bc1ad8f3c88f649b1ee50ddb2674d
treeae08087b36fcc85a0e0d12cc3b989d89930f3d24
parentdb720c4bd4980ffc9134dc6e84fdb960cfcf7e0b
LP#1482757: Remove 'orphaned_uri_list' and 'NOT cn.deleted' criteria

Per Dan Wells' suggestions.

1) One possible "crack" I see for data to fall through is the dead map
selector. The "AND cn.label = '##URI##' AND NOT cn.deleted" seems overly
restrictive. Now, I realize we *shouldn't* have mappings to deleted or
non-##URI## call numbers, but it isn't impossible, and I don't think we'd
have harm in leaving those restrictions out. If a map isn't used, let's
get rid of it regardless, I think.

2) (side note) orphaned_uri_list doesn't seems to be used any more, so
should be removed.

Signed-off-by: Michele Morgan <mmorgan@noblenet.org>
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.biblio.extract_located_uris.sql