Last modified: 2008-12-14 20:29:40 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T18647, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 16647 - Neither list=allcategories nor prop=categoryinfo actually return the 'hidden' property
Neither list=allcategories nor prop=categoryinfo actually return the 'hidden'...
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
API (Other open bugs)
1.14.x
All All
: Normal normal (vote)
: ---
Assigned To: Roan Kattouw
: patch
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2008-12-14 20:07 UTC by Brad Jorsch
Modified: 2008-12-14 20:29 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments
Patch (1.79 KB, patch)
2008-12-14 20:07 UTC, Brad Jorsch
Details

Description Brad Jorsch 2008-12-14 20:07:48 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 ('...');
Comment 1 Roan Kattouw 2008-12-14 20:29:40 UTC
Applied patch in r44590.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links