From 7d2793f82e21747ef0af9ad94e41c770d319e435 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Tue, 22 Feb 2022 13:17:04 -0500 Subject: [PATCH] LP1937294: Fix another invalid XPath expression error There was a typo further down in authority.generate_overlay_template that was missed when the previous error was corrected. This commit replaces an erroneous ( with the correct *. Signed-off-by: Jason Stephenson Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/011.schema.authority.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/011.schema.authority.sql b/Open-ILS/src/sql/Pg/011.schema.authority.sql index b9cabd3c15..b041f70288 100644 --- a/Open-ILS/src/sql/Pg/011.schema.authority.sql +++ b/Open-ILS/src/sql/Pg/011.schema.authority.sql @@ -613,7 +613,7 @@ BEGIN FOR main_entry IN SELECT * FROM authority.control_set_authority_field acsaf WHERE acsaf.control_set = cset AND acsaf.main_entry IS NULL LOOP auth_field := XPATH('//*[local-name()="datafield" and @tag="'||main_entry.tag||'"][1]',source_xml::XML); auth_i1 := (XPATH('//*[local-name()="datafield"]/@ind1',auth_field[1]))[1]; - auth_i2 := (XPATH('//([local-name()="datafield"]/@ind2',auth_field[1]))[1]; + auth_i2 := (XPATH('//*[local-name()="datafield"]/@ind2',auth_field[1]))[1]; IF ARRAY_LENGTH(auth_field,1) > 0 THEN FOR bib_field IN SELECT * FROM authority.control_set_bib_field WHERE authority_field = main_entry.id LOOP SELECT XMLELEMENT( -- XMLAGG avoids magical creation, but requires unnest subquery -- 2.11.0