Last modified: 2011-04-14 15:13:01 UTC
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.
Updated summary to vaguely reflect the problem.