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
    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 =
'' OR ((ipb_range_start LIKE '%' ) AND (ipb_range_start <= '')
AND (ipb_range_end >= ''))

The is redacted, but the empty LIKE '%' and <= '' clauses are

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

Reply via email to