List view sort buttons cause incorrect relationship type data to show

[rilrom]

Describe the Bug

When relationship types are used in list view columns, the data shown becomes incorrect when using the sort buttons.

list-view-relationship-sort-issue.mp4

Link to the code that reproduces this issue

https://github.com/rilrom/payload/tree/list-view-relationship-sort-issue

Reproduction Steps

1. Upload a file to the media collection.
2. Create another post with the recently uploaded file connected to it.
3. Use the sort buttons in the collection list view.
4. Eventually the file will appear in both rows.

Which area(s) are affected? (Select all that apply)

area: ui

Environment Info

node: 20.17.0
pnpm: 9.7.1
next: 15.0.0
payload: 3.0.0-beta.124
@payloadcms/payload-db-postgres: 3.0.0-beta.124

[linus-ha]

This also happens, when switching between pages in a collection with an upload field. Especially, when the item, at the same position of the new page, has no file selected.