Page MenuHomePhabricator

Review queries on quarry using rev_comment field
Open, Needs TriagePublic

Description

With T174569: Schema change for refactored comment storage revision.rev_comment goes and is replaced by revision.rev_comment_id and comment.comment_text.

Many of our queries used to calculate the impact of imports or edit campaigns have made use of the rev_comment field and need to be updated. See e.g. https://quarry.wmflabs.org/query/23127

Event Timeline

Lokal_Profil added a subscriber: Alicia_Fagerving_WMSE.

@Alicia_Fagerving_WMSE just checking with you first that you haven't done this while I was away.

Reedy renamed this task from Review queries on quary using rev_comment field to Review queries on quarry using rev_comment field.Feb 10 2020, 11:15 PM
Reedy updated the task description. (Show Details)

https://quarry.wmflabs.org/query/43695 can be used as a template for both the revision.rev_user_name and revision.rev_comment changes