Load more in comment feed sometimes shows the same comment twice
This happens for a couple of reasons. The example above is an older post with several comments tied at the same score, and the group of tied comments ends up divided at the "Load more" boundary, and when we do the query for comments again in response to "Load more" the database returns the tied comments in a different order. We could fix that by adding some kind of tiebreaker order_by
to the query. The harder problem is on newer posts when due to other people voting, comments could be returned in a different order because their scores have changed in between the original page load and the "load more" request, and I don't know how to fix that one without making the front end smart enough to know which comments it already has and which are new and to make an effort to remove the duplicates and get them in the correct order.