From afc8bbe476111077a7cd04bf71f6d4ec758ed58c Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 14 Aug 2017 12:12:01 -0400 Subject: [PATCH] JBAS-1554 Circ history checker log correct offset Log the correct 0-based offset when reporting patrons that have un-migrated circulations. This makes manually repairing them easier. Signed-off-by: Bill Erickson --- KCLS/sql/schema/tools/circ-history-migrate-check.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/KCLS/sql/schema/tools/circ-history-migrate-check.sql b/KCLS/sql/schema/tools/circ-history-migrate-check.sql index 50965ca5d2..dc7877d3b5 100644 --- a/KCLS/sql/schema/tools/circ-history-migrate-check.sql +++ b/KCLS/sql/schema/tools/circ-history-migrate-check.sql @@ -41,7 +41,8 @@ BEGIN IF FOUND THEN migrated_count := migrated_count + 1; ELSE - RAISE NOTICE 'User % [offset=%] has pending circs', cur_usr, usr_count; + RAISE NOTICE 'User % [offset = %] has pending circs', + cur_usr, (usr_count - 1); pending_count := pending_count + 1; END IF; END LOOP; -- 2.11.0