Fix located URI merging in action.merge_record_assets()
authorDan Scott <dscott@laurentian.ca>
Thu, 13 Oct 2011 15:49:45 +0000 (11:49 -0400)
committerDan Scott <dscott@laurentian.ca>
Fri, 11 Nov 2011 20:38:04 +0000 (15:38 -0500)
commitbda23659f6cd26656e1363ea18f2cdaeeb57631f
treec8c9b4aba5116d5f81fea1c3d1b90404d0933cc9
parent3435652d9bdf6d325e086fa8b3e6e5874f9f8f1e
Fix located URI merging in action.merge_record_assets()

Perhaps due to the unexpected results of the XPath expression, which
returns a count of nodes for subfields, etc, rather than just a count of
the number of 856 datafields, NULL was being concatenated onto a string
- which of course made the string NULL.

Use COALESCE() to prevent the NULLness from spreading and enable
action.merge_record_assets() to do the right thing.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset_merge_record_assets.sql [new file with mode: 0644]