Testing rev_actor on Commons

SQL

#SELECT * FROM commonswiki_p.revision
#WHERE rev_page = 82302461; # page id from https://commons.wikimedia.org/w/index.php?title=File:Patrolling_on_Wikipedia_September_2019_research_showcase_slides.pdf&action=info
#yields the correct page, but yields "2386505" for the id of the user instead of "2218619" which is my ID

#SELECT * from commonswiki_p.user where user_id = 2218619;
#yields "Jmorgan (WMF)

#SELECT * from commonswiki_p.user where user_id = 2386505;
# yields "Evakuznet"

#describe commonswiki_p.actor;
#okay, this maps from actor_id to (old?) user_id it seems
#SELECT * FROM commonswiki_p.actor where actor_id = 2386505;
#yields "2218619" for actor_user and "Jmorgan (WMF)" for actor_name. So these ids are different. Okay.

SELECT * FROM commonswiki_p.actor where actor_name = "Keegan (WMF)";
SQL

Checking query status...
