r83812, r83814: Don't use cl_type at all when paging categorylinks
authorMarcin Cieślak <saper@users.mediawiki.org>
Tue, 15 Mar 2011 02:53:00 +0000 (02:53 +0000)
committerMarcin Cieślak <saper@users.mediawiki.org>
Tue, 15 Mar 2011 02:53:00 +0000 (02:53 +0000)
commit274d317a0ca2777a5c5fae2007c53811397540f5
tree67f3541d4443b4cfa9d074adb998b0ca74a912cc
parent55fc4f6a86efe34a73a4226f17cc5477b9374bcc
r83812, r83814: Don't use cl_type at all when paging categorylinks

* Remove cl_type from paging in categorylinks - it's not
  really needed there. Although cl_type is in WHERE but not
  in ORDER BY clause the worst thing that can happen
  is to have a filesort going again through <500 entries
  selected by index. Or will FORCE INDEX work anyway?

* Revert schema change, as we don't need cl_type there
  anyway (or even if we wanted to compare, it should
  work as expected by using INT values against ENUM).
includes/api/ApiQueryCategoryMembers.php
includes/installer/MysqlUpdater.php
maintenance/archives/patch-cl_type.sql [deleted file]
maintenance/tables.sql