https://bugzilla.wikimedia.org/show_bug.cgi?id=60035
Web browser: ---
Bug ID: 60035
Summary: Block::newLoad malformed db query
Product: MediaWiki
Version: 1.23-git
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: sprin...@wikimedia.org
Classification: Unclassified
Mobile Platform: ---
Found examples of the following in the slow logs:
SELECT /* Block::newLoad */ ipb_id, ipb_address, ipb_by, ipb_by_text,
ipb_reason, ipb_timestamp, ipb_auto, ipb_anon_only, ipb_create_account,
ipb_enable_autoblock, ipb_expiry, ipb_deleted, ipb_block_email,
ipb_allow_usertalk, ipb_parent_block_id FROM `ipblocks` WHERE ipb_address =
'xxx.xxx.xxx.xxx' OR ((ipb_range_start LIKE '%' ) AND (ipb_range_start <= '')
AND (ipb_range_end >= ''))
The xxx.xxx.xxx.xxx is redacted, but the empty LIKE '%' and <= '' clauses are
verbatim.
This seems wrong, and in any case causes a table scan which hurts on enwiki.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
