תגובות בשרשור מוצגות לא לפי הסדר

Running the query from posts:reorder_posts shows that the sort_order for a number of posts is odd, and looks like the rake should update them, but it does not.


From running:

SELECT
id,
post_number,
sort_order,
ROW_NUMBER() OVER (
    PARTITION BY
    topic_id
    ORDER BY
    created_at,
    post_number
) AS new_post_number
FROM
posts