Protect biblio.extract_located_uris() from a NULL uri_use value by using the href...
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 18 Oct 2010 19:05:19 +0000 (19:05 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 18 Oct 2010 19:05:19 +0000 (19:05 +0000)
commit53e98d6439ea27d1a275d314d00e0954fb968078
tree9e8103df68d98a00938458b734b607aa49cd3b5e
parent87f38a32caf555fb72a8023109e35afae2d0a866
Protect biblio.extract_located_uris() from a NULL uri_use value by using the href as a fallback

If an 856 field contained a subfield "9" but did not contain a subfield
"z", "2", or "n", then ingest of the MARC record would fail as it attempted
to retrieve an asset.uri row where uri_use = NULL - which was never true.

This change adds the subfield "u" to fall back to for the uri_use variable,
just like we do for the uri_label variable, and prevents ugly ingest errors
from getting thrown back at the client.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@18382 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql
Open-ILS/src/sql/Pg/upgrade/0440.schema.biblio_extract_located_uris.sql [new file with mode: 0644]