---
title: "Important: List ordering ties are broken by uid"
manual: "Academic Projects"
version: "main"
source: "Changelog/3.0/Important-ListOrderingTiesAreBrokenByUid.rst"
rendered: "2026-09-22T20:39:25+00:00"
---

# Important: List ordering ties are broken by uid {#important-list-ordering-ties-are-broken-by-uid}

## Description {#description}

`ProjectRepository::findByDemand()` orders by the sorting
option the plugin demands — and by nothing else, so 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 {#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 {#affected-installations}

Every installation of this extension.