Page MenuHomePhabricator

Updater: cl_sortkey didn't cover cl_type
Closed, InvalidPublic

Description

tables.sql contains the following senctence:

  • FIXME:
  • Formerly this index didn't cover cl_type (since that didn't exist), so old
  • callers won't be using an index: fix this?

CREATE INDEX /*i*/cl_sortkey ON /*_*/categorylinks (cl_to,cl_type,cl_sortkey,cl_from);

Please evaluate the timeframe this index was without cl_from and write a update step to the Updater. If the timeframe is short, you can set this to WONTFIX and skip the update step. Thanks.


Version: 1.23.0
Severity: normal

Details

Reference
bz56858

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 2:26 AM
bzimport set Reference to bz56858.
bzimport added a subscriber: Unknown Object (MLST).
duplicatebug claimed this task.

per bug report