]> git.evergreen-ils.org Git - Evergreen.git/commit
Fix located URI merging in action.merge_record_assets()
authorDan Scott <dscott@laurentian.ca>
Thu, 13 Oct 2011 17:14:13 +0000 (13:14 -0400)
committerMike Rylander <mrylander@gmail.com>
Thu, 13 Oct 2011 20:01:00 +0000 (16:01 -0400)
commit71189a3d1ac01780a2f537b532a9d68433cf0ab2
treec550b35bf3daaf3648d33322498b0f05cf086d0c
parentde77be3ecb507cb6563310a5a0f4bcb8c2bf2786
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/999.functions.global.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset_merge_record_assets.sql [new file with mode: 0644]