From: Rogan Hamby Date: Wed, 22 May 2019 12:54:18 +0000 (-0400) Subject: Merge branch 'master' of git.esilibrary.com:migration-tools X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=a212c25811ff0694d76573252ffcda63d0816ebd;hp=8b6eace4dd39b1fbaede125fc1e6757a4e63754c Merge branch 'master' of git.esilibrary.com:migration-tools --- diff --git a/sql/base/base.sql b/sql/base/base.sql index d5bcdc8..46d221a 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -5445,7 +5445,7 @@ BEGIN RAISE INFO '% incumbent barcode collisions', incumbent_barcode_collision_count; FOR x_barcode IN - SELECT a.usrname FROM actor.usr a, actor_usr_legacy b WHERE x_migrate AND a.deleted IS FALSE AND a.usrname = b.usrname + SELECT a.usrname FROM actor.usr a, actor_usr_legacy b WHERE x_migrate AND a.usrname = b.usrname LOOP FOR x_id IN SELECT DISTINCT id FROM actor_usr_legacy WHERE x_migrate AND usrname = x_barcode LOOP