X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2Fbase.sql;h=2607c9578f8cc9e27236b1da675fd52b93240982;hp=f9fe57eeb1a5473aeb9cdf42ec8953175ff3c8c1;hb=aacf49e00625e2ca75279e8b721167ee7697dd26;hpb=7754bb8efebb2ffda7406f2d0d736b6377ba589b diff --git a/sql/base/base.sql b/sql/base/base.sql index f9fe57e..2607c95 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -5291,7 +5291,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