Last modified: 2008-12-14 20:29:40 UTC
Created attachment 5582 [details] 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 ('...');
Applied patch in r44590.