X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2Fbase.sql;h=46d221a0a54c5b998943af731c1f8746b76cbfbc;hp=d5bcdc88c04fa2bd6d60b05a148779e8d1461dea;hb=a212c25811ff0694d76573252ffcda63d0816ebd;hpb=8b6eace4dd39b1fbaede125fc1e6757a4e63754c 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