The schema change can be found at https://gerrit.wikimedia.org/r/#/c/122349/5/maintenance/archives/patch-pp_sortkey.sql, reproduced here as well:
ALTER TABLE /*_*/page_props
ADD pp_sortkey float DEFAULT NULL;
CREATE UNIQUE INDEX /*i*/pp_propname_sortkey_page
ON /*_*/page_props ( pp_propname, pp_sortkey, pp_page );
This is hidden behind a feature flag so there's no rush to have this done before a set deployment.
Version: wmf-deployment
Severity: enhancement
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T96040 Wikibase special pages (tracking) | |||
| Declined | Ricordisamoa | T48217 Implement a special page to show items with the most sitelinks | |||
| Declined | None | T41150 [Story] Create Special:EmptyItems | |||
| Declined | None | T45732 [Task] Make a special page to list "stub" entities | |||
| Resolved | None | T60032 Allow page_props to be queried by value. | |||
| Resolved | Springle | T66411 Deploy pp_sortkey schema change to all wikis |
Change 130055 had a related patch set uploaded by Aude:
Set $wgPagePropsHaveSortkey to false
Strictly speaking the bug is complete, however the linked patch set is unmerged and possibly still needed until the field is prepopulated by a batch job?
Change 130055 abandoned by Aude:
Set $wgPagePropsHaveSortkey to false
Reason:
schema change is done