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 ('...');

Version: 1.14.x
Severity: normal

Attached: