[Wikidata-bugs] [Maniphest] [Commented On] T165311: Investigate title normalization clashes

[daniel]

daniel added a comment.

Checked for enwiktionary, found 6 pairs of pages:

mysql:wikiadmin@10.64.16.18 [cognate_wiktionary]> SELECT a.cgti_raw, b.cgti_raw
    -> FROM cognate_titles as a
    ->   JOIN cognate_titles as b ON a.cgti_normalized_key = b.cgti_normalized_key
    ->   JOIN cognate_pages as p ON p.cgpa_title = a.cgti_raw_key 
    ->     and p.cgpa_namespace = 0 and p.cgpa_site = 8711873510529828948
    ->   JOIN cognate_pages as q ON q.cgpa_title = b.cgti_raw_key 
    ->     and q.cgpa_namespace = 0 and q.cgpa_site = 8711873510529828948
    ->   WHERE a.cgti_raw_key < b.cgti_raw_key 
    -> LIMIT 10;
+---------------------------+-----------------------------+
| cgti_raw                  | cgti_raw                    |
+---------------------------+-----------------------------+
| дев'ятнадцять             | дев’ятнадцять               |
| ...                       | …                           |
| '_'                       | ’_’                         |
| ’                         | '                           |
| lu’um                     | lu'um                       |
| ni'                       | ni’                         |
+---------------------------+-----------------------------+
6 rows in set (39.45 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T165311

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: daniel
Cc: Addshore, Lydia_Pintscher, Lea_Lacroix_WMDE, Aklapper, daniel, GoranSMilovanovic, QZanden, Thibaut120094, Izno, Wikidata-bugs, aude, GPHemsley, Darkdadaah, Mbch331, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs