Important: List ordering ties are broken by uid
Description
Project ordered by the sorting option the
plugin demands, and by nothing else. Records equal in that ordering (two
projects with the same title, for example) were returned in whatever relative
order the database yielded. On PostgreSQL that is not the same list twice. The
query now appends
uid
ascending as a tiebreaker.
Impact
No visible change is expected on SQLite, MySQL and MariaDB: within records equal
in the demanded ordering,
uid
ascending is the order they return in
practice, and it is guaranteed now rather than coincidental. PostgreSQL promises
no order without one, so an installation on it may see such a list change once.
Affected Installations
Every installation of this extension.