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:10:13 +0000 (19:10 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 18 Oct 2010 19:10:13 +0000 (19:10 +0000)
commitc16b7ac4b7d1a72fcc12c18f12545b109a3a3f87
tree3a35f2774b89ef9f258bc1c984fd80c517e07a74
parenta59fcb3989edf94b9f19990e6b8659422f29be07
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/branches/rel_2_0@18383 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]