According to the documentation, interwiki.iw_prefix is varbinary(32), while iwlinks.iwl_prefix is only varbinary(20). This may result in truncated interwiki prefixes in the iwlinks table and bugs such as this query where the prefix should be archlinux-service-agreements, but instead it is truncated to archlinux-service-ag.
Description
Description
Details
Details
| Project | Branch | Lines +/- | Subject | |
|---|---|---|---|---|
| mediawiki/core | REL1_35 | +89 -1 | Extend iwlinks.iwl_prefix to VARBINARY(32) on MySQL | |
| mediawiki/core | master | +90 -2 | Extend iwlinks.iwl_prefix to VARBINARY(32) on MySQL |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Reedy | T275242 iwlinks.iwl_prefix should be the same length as interwiki.iw_prefix | |||
| Open | None | T277123 Extend iwlinks.iwl_prefix to VARBINARY(32) |
Event Timeline
Comment Actions
Looks like this has always been the case since iwlinks was added in T16473: Sister project (interwiki) links should be stored in their own table
Comment Actions
Change 665454 had a related patch set uploaded (by Reedy; owner: Reedy):
[mediawiki/core@master] WIP: Extend iwlinks.iwl_prefix to length 32
Comment Actions
Change 665454 merged by jenkins-bot:
[mediawiki/core@master] Extend iwlinks.iwl_prefix to VARBINARY(32) on MySQL
Comment Actions
Change 666698 had a related patch set uploaded (by Reedy; owner: Reedy):
[mediawiki/core@REL1_35] Extend iwlinks.iwl_prefix to VARBINARY(32) on MySQL
Comment Actions
Change 666698 merged by jenkins-bot:
[mediawiki/core@REL1_35] Extend iwlinks.iwl_prefix to VARBINARY(32) on MySQL