Don't target log_user_text for registered users
authorBrad Jorsch <bjorsch@wikimedia.org>
Tue, 6 Mar 2018 16:18:45 +0000 (11:18 -0500)
committerAnomie <bjorsch@wikimedia.org>
Tue, 6 Mar 2018 16:22:35 +0000 (16:22 +0000)
Apparently when log_user_text was added no one bothered to populate it
for existing rows. Sigh, #Technical-Debt.

Bug: T188826
Change-Id: Ice1e6454e439a4abdf9594f6e964478dd484bc20

includes/api/ApiQueryLogEvents.php
includes/logging/LogPager.php

index 68902a3..84e12d7 100644 (file)
@@ -172,10 +172,8 @@ class ApiQueryLogEvents extends ApiQueryBase {
                if ( !is_null( $user ) ) {
                        // Note the joins in $q are the same as those from ->getJoin() above
                        // so we only need to add 'conds' here.
-                       // Don't query by user ID here, it might be able to use the
-                       // log_user_text_time or log_user_text_type_time index.
                        $q = $actorMigration->getWhere(
-                               $db, 'log_user', User::newFromName( $params['user'], false ), false
+                               $db, 'log_user', User::newFromName( $params['user'], false )
                        );
                        $this->addWhere( $q['conds'] );
                }
index d1acacf..24fdfb0 100644 (file)
@@ -178,10 +178,8 @@ class LogPager extends ReverseChronologicalPager {
                $name = $usertitle->getText();
 
                // Assume no joins required for log_user
-               // Don't query by user ID here, it might be able to use the
-               // log_user_text_time or log_user_text_type_time index.
                $this->mConds[] = ActorMigration::newMigration()->getWhere(
-                       wfGetDB( DB_REPLICA ), 'log_user', User::newFromName( $name, false ), false
+                       wfGetDB( DB_REPLICA ), 'log_user', User::newFromName( $name, false )
                )['conds'];
 
                $this->enforcePerformerRestrictions();