https://bugzilla.wikimedia.org/show_bug.cgi?id=18447

           Summary: AntiSpoof clobbering mixed case users.
           Product: MediaWiki extensions
           Version: any
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: Normal
         Component: AntiSpoof
        AssignedTo: [email protected]
        ReportedBy: [email protected]


Say there's an existing user named Sriniw8z in the wiki. This get's normalized
to: v2:5R1N1W8Z

Say this user has been gone for many many years so you override AntiSpoof to
create a user named:

SRINIW8Z, which also gets normalized into v2:5R1N1W8Z.

Now in the spoofusers table, you'd expect to see both entries?

However in MySQL's case insenitive nature, it clobbers the old entry since the
query in batchRecord uses a replace call, and you just get the second one
listed.  This throws off later AntiSpoof checks as they'll only show one
similar user, instead of multiple.

Seems to work as intended with PG, I dont know if this is an artifact of the
old DB style WMF uses, I dont have a new UTF-8 MySQL to test on.


-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to