Page MenuHomePhabricator

Results go missing between pages when paginating on non-unique field
Open, Needs TriagePublic

Description

Since T244492, IndexPagers can sort results by multiple columns/fields.

Because IndexPager uses cursor pagination, if the sort field is not unique, results can go missing between pages. Several pagers still sort by a single, non-unique field - a common example is sorting by timestamp (not usually unique).

These cases can often be fixed by sorting by (timestamp, primary key).