Author: river
Description:
following query runs on dewiki:
UPDATE /* update_flaggedrevs 127.0.0.1 */ flaggedrevs SET fr_quality = '0',fr_img_name = NULL,fr_img_sha1 = NULL,fr_img_timestamp = NULL WHERE fr_rev_id = '8648547';
however, there is no index on fr_rev_id, only (fr_page_id,fr_rev_id). therefore no index is used for the query.
Version: unspecified
Severity: critical