https://bugzilla.wikimedia.org/show_bug.cgi?id=21817





--- Comment #2 from P.Copp <[email protected]>  2009-12-11 09:36:31 
UTC ---
Created an attachment (id=6871)
 --> (https://bugzilla.wikimedia.org/attachment.cgi?id=6871)
Proposed fix: Add check for empty 'ucuser=' parameter to
ApiQueryUserContributions.php

I suspect this may be the reason why it has been disabled:

api.php?action=query&list=ucercontribs&user=

results in

SELECT /* ApiQueryContributions::execute 127.0.0.1 */ 
rev_timestamp,page_namespace,page_title,rev_user_text,rev_deleted,rev_page,rev_id,page_latest,rev_comment,rev_len,rev_minor_edit,rev_parent_id
 FROM `page`,`revision` FORCE INDEX (usertext_timestamp)   WHERE
(page_id=rev_page) AND ((rev_deleted & 4) = 0)  ORDER BY rev_timestamp DESC
LIMIT 11

which will filesort the entire revision table due to the missing
'rev_user_text'-condition.


-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to