Wikimedia Bugzilla is closed!

Forcing an index on a select query when doing a table join gives a query error, we get

SELECT page_title,page_namespace FROM `mw_page` JOIN `mw_categorylinks` ON ((page_id=cl_from)) FORCE INDEX (page_random) WHERE page_is_redirect = '0' AND (page_random >= 0.757003172866) AND cl_to = 'Test' ORDER BY page_random LIMIT 1

from within function "RandomPage::selectRandomPageFromDB". Database returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FORCE INDEX (page_random) WHERE page_is_redirect = '0' AND (page_random >= 0.757' at line 1 (localhost)".

When we want

SELECT page_title,page_namespace FROM `mw_page` FORCE INDEX (page_random) JOIN `mw_categorylinks` ON ((page_id=cl_from))  WHERE page_is_redirect = '0' AND (page_random >= 0.757003172866) AND cl_to = 'Test' ORDER BY page_random LIMIT 1


Noticed when refactoring RandomPage and RandomInCategory to reduce code duplication