Page MenuHomePhabricator

Revisions where rev_user_text differs from user_name
Open, Needs TriagePublic

Description

While looking into T111605 I saw that, at least on de.wiki, there are multiple revisions where rev_user_text doesn't agree with user_name. They seem to be renamed users, no idea whether it has to do with import or not.

Cf. T47746: Partial rename for specific user on collabwiki

MariaDB [dewiki_p]> SELECT rev_id, rev_user_text, user_name FROM revision JOIN logging ON rev_page = log_page AND log_type = 'import' JOIN user ON user_id = rev_user AND user_name <> rev_user_text WHERE rev_user > 0 AND rev_user_text NOT RLIKE '(^([0-9]{1,3}[.]){3}[0-9]{1,3}$|^([[:alnum:]]{1,4}[:]){7})' AND rev_page > 0 AND rev_timestamp < log_timestamp;
+----------+------------------+----------------+
| rev_id   | rev_user_text    | user_name      |
+----------+------------------+----------------+
| 65704381 | Justbridge       | Justus Brücke  |
| 65704381 | Justbridge       | Justus Brücke  |
| 70359432 | Daniele Pugliesi | Aushulz        |
| 71300545 | Justbridge       | Justus Brücke  |
| 71055673 | Onee             | O.Koslowski    |
| 71552070 | Wolf32at         | DerGraueWolf   |
| 71565974 | Justbridge       | Justus Brücke  |
| 72031462 | Schomynv         | Mme Mim        |
| 71521249 | Wolf32at         | DerGraueWolf   |
| 72188986 | Justbridge       | Justus Brücke  |
| 72189041 | Justbridge       | Justus Brücke  |
| 76268012 | Daniele Pugliesi | Aushulz        |
| 80066897 | Wolf32at         | DerGraueWolf   |
| 80104475 | Wolf32at         | DerGraueWolf   |
| 80104490 | Wolf32at         | DerGraueWolf   |
| 80275224 | Wolf32at         | DerGraueWolf   |
| 81711131 | Schomynv         | Mme Mim        |
| 82198242 | Wolf32at         | DerGraueWolf   |
| 82696379 | Onee             | O.Koslowski    |
| 82161477 | Wolf32at         | DerGraueWolf   |
| 83372859 | Schomynv         | Mme Mim        |
| 84881377 | Daniele Pugliesi | Aushulz        |
| 84881378 | Daniele Pugliesi | Aushulz        |
| 71243433 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88657167 | Wolf32at         | DerGraueWolf   |
| 88838955 | Wolf32at         | DerGraueWolf   |
| 88838955 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 88914751 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89043632 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89093460 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89142041 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 89178635 | Wolf32at         | DerGraueWolf   |
| 90316474 | Wolf32at         | DerGraueWolf   |
| 90316474 | Wolf32at         | DerGraueWolf   |
| 90316474 | Wolf32at         | DerGraueWolf   |
| 90316474 | Wolf32at         | DerGraueWolf   |
| 90392157 | Wolf32at         | DerGraueWolf   |
| 90392157 | Wolf32at         | DerGraueWolf   |
| 90392157 | Wolf32at         | DerGraueWolf   |
| 90392157 | Wolf32at         | DerGraueWolf   |
| 90452954 | Wolf32at         | DerGraueWolf   |
| 90452954 | Wolf32at         | DerGraueWolf   |
| 90452954 | Wolf32at         | DerGraueWolf   |
| 90452954 | Wolf32at         | DerGraueWolf   |
| 90470725 | Wolf32at         | DerGraueWolf   |
| 90470725 | Wolf32at         | DerGraueWolf   |
| 71309622 | Justbridge       | Justus Brücke  |
| 94168877 | Wolf32at         | DerGraueWolf   |
| 94168879 | Wolf32at         | DerGraueWolf   |
| 94169816 | Wolf32at         | DerGraueWolf   |
| 94169818 | Wolf32at         | DerGraueWolf   |
| 94751417 | Wolf32at         | DerGraueWolf   |
| 95715586 | GoAvs            | Avaholic       |
| 98491034 | Schomynv         | Mme Mim        |
| 99800361 | Daniele Pugliesi | Aushulz        |
| 99800362 | Daniele Pugliesi | Aushulz        |
| 99800365 | Daniele Pugliesi | Aushulz        |
| 70093631 | Justbridge       | Justus Brücke  |
| 70093644 | Justbridge       | Justus Brücke  |
| 70093693 | Justbridge       | Justus Brücke  |
| 70093739 | Justbridge       | Justus Brücke  |
| 80124540 | Wolf32at         | DerGraueWolf   |
+----------+------------------+----------------+
102 rows in set (1 min 3.93 sec)

Query too slow to run:

SELECT rev_id, rev_user_text, user_name
    -> FROM revision
    -> JOIN user
    -> ON user_id = rev_user
    -> AND user_name <> rev_user_text;

Event Timeline

Nemo_bis raised the priority of this task from to Needs Triage.
Nemo_bis updated the task description. (Show Details)
Nemo_bis added a subscriber: Nemo_bis.
Restricted Application added subscribers: Matanya, Aklapper. · View Herald TranscriptSep 12 2015, 10:34 AM
Nemo_bis renamed this task from Revisions where rev_user_text doesn't differs from user_name to Revisions where rev_user_text differs from user_name.Sep 12 2015, 10:35 AM
Nemo_bis set Security to None.
Scott added a subscriber: Scott.Sep 12 2015, 1:05 PM
Restricted Application added a subscriber: StudiesWorld. · View Herald TranscriptNov 8 2015, 10:15 PM
Akeron added a subscriber: Akeron.Jun 16 2016, 9:27 AM
Restricted Application added a subscriber: JEumerus. · View Herald TranscriptJun 16 2016, 9:27 AM