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

[daniel]

daniel added a comment.

ruwiktionary:

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 = -235854953179375905 JOIN cognate_pages as q ON q.cgpa_title = b.cgti_raw_key      and q.cgpa_namespace = 0 and q.cgpa_site = p.cgpa_site WHERE a.cgti_raw_key < b.cgti_raw_key limit 30;
+---------------------+-------------------+
| cgti_raw            | cgti_raw          |
+---------------------+-------------------+
| misk'i              | misk’i            |
| sil'm               | sil’m             |
| arc’hant            | arc'hant          |
| маловір’я           | маловір'я         |
| erc’h               | erc'h             |
| мар’                | мар'              |
| п’ятниця            | п'ятниця          |
| saba’               | saba'             |
| хэм'                | хэм’              |
+---------------------+-------------------+
9 rows in set (35.87 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