]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#1116509: prevent null SVF attribute value from breaking record import
authorGalen Charlton <gmc@esilibrary.com>
Tue, 5 Feb 2013 18:12:02 +0000 (13:12 -0500)
committerMike Rylander <mrylander@gmail.com>
Mon, 11 Mar 2013 19:38:32 +0000 (15:38 -0400)
commit2f422efb600ed67eb086f3f4f130298a934f07ef
tree90fa1a3e0145f2e37c4a4192284a094a8a9fa86c
parent369834f5ece9755a5a43d29f31afa70e2a4909c7
LP#1116509: prevent null SVF attribute value from breaking record import

Fix problem where a record could fail to be staged for import
with the following error:

ERROR: query string argument of EXECUTE is null
CONTEXT: PL/pgSQL function "extract_rec_attrs" line 72 at EXECUTE statement
SQL function "extract_rec_attrs" statement 1

This error would be triggered if at least one SVF attribute has a normalization
function defined that is applied to a null value during record import.

Patch is based on a suggestion by Bob Wicksall.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/012.schema.vandelay.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.handle_null_svf_during_import.sql [new file with mode: 0644]