Page MenuHomePhabricator

Fix an issue where paginating notifications could fail a GROUP BY test
ClosedPublic

Authored by epriestley on Feb 26 2021, 6:45 PM.
Tags
None
Referenced Files
Unknown Object (File)
Feb 15 2024, 9:36 PM
Unknown Object (File)
Jan 20 2024, 4:52 PM
Unknown Object (File)
Jan 9 2024, 9:08 PM
Unknown Object (File)
Dec 26 2023, 10:31 AM
Unknown Object (File)
Dec 23 2023, 7:47 PM
Unknown Object (File)
Dec 22 2023, 12:02 PM
Unknown Object (File)
Dec 1 2023, 12:42 PM
Unknown Object (File)
Dec 1 2023, 12:47 AM
Subscribers
None

Details

Summary

Ref T13623. When paginating notifications, we may currently construct a query which:

  • loads from non-unique rows; and
  • returns multiple results.

In particular, chronologicalKey isn't unique across the whole table (only for a given viewer). We can get away with this because no user-facing view of notifications is truly "every notification for every viewer" today.

One fix would be to implicitly force the paging query to include withUserPHIDs(viewerPHID), but puruse a slightly more general fix:

  • Load only unique stories.
  • Explictly limit the pagination subquery to one result.
Test Plan
  • Set page size to 1, inserted duplicate notifications of all stories for another user, clicked "Next", got the GROUP BY error.
  • Applied the "only load unique stories" part of the change, got a "expected one row" error instead.
  • Applied the "limit 1" part of the change, got a second page of notifications.

Diff Detail

Repository
rP Phabricator
Lint
Lint Not Applicable
Unit
Tests Not Applicable