From f7c0d356fd68639ebb094aeaf4b2a54b54fdbecb Mon Sep 17 00:00:00 2001 From: Jeff Davis Date: Mon, 23 Sep 2019 16:15:14 -0700 Subject: [PATCH] LP#1845260: fix error in vandelay.auto_overlay_org_unit_copies db function Signed-off-by: Jeff Davis Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/012.schema.vandelay.sql | 2 +- .../Pg/upgrade/1182.schema.vandelay.auto_overlay_org_unit_copies.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql index 732be40a6d..64fd6cdb15 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -1885,7 +1885,7 @@ BEGIN -- These are our initial scope_orgs. SELECT ARRAY_AGG(DISTINCT owning_lib) INTO scope_orgs FROM vandelay.import_item - WHERE queued_record = import_id; + WHERE record = import_id; WHILE CARDINALITY(scope_orgs) > 0 LOOP FOR scope_org IN SELECT * FROM UNNEST(scope_orgs) LOOP diff --git a/Open-ILS/src/sql/Pg/upgrade/1182.schema.vandelay.auto_overlay_org_unit_copies.sql b/Open-ILS/src/sql/Pg/upgrade/1182.schema.vandelay.auto_overlay_org_unit_copies.sql index 13816a30bc..70a4b3e11b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/1182.schema.vandelay.auto_overlay_org_unit_copies.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1182.schema.vandelay.auto_overlay_org_unit_copies.sql @@ -31,7 +31,7 @@ BEGIN -- These are our initial scope_orgs. SELECT ARRAY_AGG(DISTINCT owning_lib) INTO scope_orgs FROM vandelay.import_item - WHERE queued_record = import_id; + WHERE record = import_id; WHILE CARDINALITY(scope_orgs) > 0 LOOP FOR scope_org IN SELECT * FROM UNNEST(scope_orgs) LOOP -- 2.11.0