SELECT p.uuid,mw.uuid,p.name,mw.name,p.username,mw.username FROM identities p JOIN identities mw WHERE mw.source = "phabricator" AND p.source = "phabricator" AND mw.uuid != p.uuid AND mw.username = p.username AND mw.username IS NOT NULL AND p.name = "" AND mw.name IS NULL ORDER BY mw.username;
Description
Description
Event Timeline
Comment Actions
The query above shows zero results, but SELECT p.uuid,mw.uuid,p.name,mw.name,p.username,mw.username FROM identities p JOIN identities mw WHERE mw.source = "phabricator" AND p.source = "phabricator" AND mw.uuid != p.uuid AND mw.username = p.username AND mw.username IS NOT NULL ORDER BY mw.username; and SELECT p.uuid,mw.uuid,p.name,mw.name,p.username,mw.username FROM identities p JOIN identities mw WHERE mw.source = "phabricator" AND p.source = "phabricator" AND mw.uuid != p.uuid AND mw.username = p.username AND mw.username IS NOT NULL AND mw.name IS NULL ORDER BY mw.username; gave a few (less than 10 items) accounts that I've listed once I can push properly when https://gitlab.com/Bitergia/c/Wikimedia/support/issues/1#note_52946363 is solved.
Comment Actions
Output of both queries looks fine now. Not exactly sure how this fixed itself but not unhappy about it. :)