From ac26a282b12bf56782b3711d1275a39fa7c86ce2 Mon Sep 17 00:00:00 2001 From: Jason Boyer Date: Wed, 6 Sep 2017 16:28:55 -0400 Subject: [PATCH] LP1715485: Syntax Error in PERFORM Its results are discarded but PERFORM still wants its star. Signed-off-by: Jason Boyer --- Open-ILS/src/sql/Pg/300.schema.staged_search.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/1057.schema.copy_vis_attr_cache.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql index fee4929217..3ff5183d9d 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -827,7 +827,7 @@ BEGIN visibility_org := NULLIF(visibility_org,-1); IF visibility_org IS NOT NULL THEN - PERFORM FROM actor.org_unit WHERE id = visibility_org AND parent_ou IS NULL; + PERFORM * FROM actor.org_unit WHERE id = visibility_org AND parent_ou IS NULL; IF FOUND THEN opac_visibility_join := ''; ELSE diff --git a/Open-ILS/src/sql/Pg/upgrade/1057.schema.copy_vis_attr_cache.sql b/Open-ILS/src/sql/Pg/upgrade/1057.schema.copy_vis_attr_cache.sql index a2497b8aa8..f747c08cbe 100644 --- a/Open-ILS/src/sql/Pg/upgrade/1057.schema.copy_vis_attr_cache.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1057.schema.copy_vis_attr_cache.sql @@ -439,7 +439,7 @@ BEGIN visibility_org := NULLIF(visibility_org,-1); IF visibility_org IS NOT NULL THEN - PERFORM FROM actor.org_unit WHERE id = visibility_org AND parent_ou IS NULL; + PERFORM * FROM actor.org_unit WHERE id = visibility_org AND parent_ou IS NULL; IF FOUND THEN opac_visibility_join := ''; ELSE -- 2.11.0