Make CategoryMembershipChangeJob query more readable
authorAaron Schulz <aschulz@wikimedia.org>
Tue, 21 Nov 2017 02:43:40 +0000 (18:43 -0800)
committerAaron Schulz <aschulz@wikimedia.org>
Tue, 21 Nov 2017 04:08:12 +0000 (04:08 +0000)
commit7ec76945e334ab9797efa6c479edd9a21a6438c9
tree567e4616acf55bd568bd36a911a37bb3dcc9d578
parent09ba8f4cbef8606e95b407cf370b270e5153b2b5
Make CategoryMembershipChangeJob query more readable

Previously, the INNER JOIN had "rc_timestamp >= rev_timestamp" which
complicates query planning. Even with "equals" it still was techinally
ambiguous. Instead, just use EXISTS and an exact equality operator.

Bug: T180793
Change-Id: I1e9ae7c2ce0f95484e09e867550283d816d151f0
includes/jobqueue/jobs/CategoryMembershipChangeJob.php