Marostegui added a comment.
I have been talking to @Anomie about this issue, and it is believed that it doesn't seem to be the same thing as T221458 <https://phabricator.wikimedia.org/T221458> or T220999 <https://phabricator.wikimedia.org/T220999>, but it is related to the `actor` change. Looks like that for the where on `rev_timestamp>='20190418104744` it could use the denormalized `revactor_timestamp` field to filter the `temp_rev_user` line. @Anomie thinks that there are two potential fixes: - change the WHERE clause to reference the denormalized field directly - change the JOIN to add a redundant equality `revactor_timestamp = rev_timestamp` which seems to work to let it know it can propagate the WHERE condition to the denormalized field. Eventually the `revision_actor_temp` will be killed once the migration is fully done, but that is not going to happen soonish. TASK DETAIL https://phabricator.wikimedia.org/T221380 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Marostegui Cc: Marostegui, Anomie, Daimona, matej_suchanek, MisterSynergy, Framawiki, TerraCodes, Liuxinyu970226, Aklapper, Jc86035, alaa_wmde, DannyS712, Nandana, Banyek, Rayssa-, Lahi, Gq86, Darkminds3113, Lsherwinforone, GoranSMilovanovic, Jayprakash12345, QZanden, LawExplorer, Vali.matei, Sethakill, _jensen, rosalieper, Volker_E, Wong128hk, Wikidata-bugs, aude, GWicke, Dinoguy1000, Jdforrester-WMF, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
