From d8fd91d04ec074f747b31eadd3eed1101de704da Mon Sep 17 00:00:00 2001 From: Jason Boyer Date: Mon, 13 Sep 2021 16:38:12 -0400 Subject: [PATCH] LP1174498: Add Missing amount=0.0 Guard to Upgrade Script Signed-off-by: Jason Boyer --- .../Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql index de84d20dc0..98fee86fa9 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql @@ -254,7 +254,9 @@ BEGIN billing_id_used = array_append( billing_id_used, current_billing_id ); END IF; - RETURN NEXT current_result; + IF current_result.amount <> 0.0 THEN + RETURN NEXT current_result; + END IF; EXIT WHEN payment_remainder = 0.0; END LOOP; -- 2.11.0