https://bugzilla.wikimedia.org/show_bug.cgi?id=16647
Summary: Neither list=allcategories nor prop=categoryinfo
actually return the 'hidden' property
Product: MediaWiki
Version: 1.14-svn
Platform: All
OS/Version: All
Status: NEW
Keywords: patch
Severity: normal
Priority: Normal
Component: API
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected], [email protected]
Created an attachment (id=5582)
--> (https://bugzilla.wikimedia.org/attachment.cgi?id=5582)
Patch
Same underlying cause as bug 15579. STRAIGHT_JOIN does not seem to be required
in this case to convince MySQL to use the smart join order. The generated
queries are:
-- allcategories
SELECT cat_title,pp_propname AS cat_hidden FROM `category` LEFT JOIN `page` ON
((page_namespace=14 AND page_title=cat_title)) LEFT JOIN `page_props` ON
((pp_page=page_id AND pp_propname='hiddencat')) ORDER BY cat_title LIMIT 11;
-- categoryinfo; fill in the "IN" clause at the end
SELECT cat_title,cat_pages,cat_subcats,cat_files,pp_propname AS cat_hidden
FROM `category` LEFT JOIN `page` ON ((page_namespace=14 AND
page_title=cat_title)) LEFT JOIN `page_props` ON ((pp_page=page_id AND
pp_propname='hiddencat')) WHERE cat_title IN ('...');
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
