GrottoCenter / grottocenter-api / 23058199764

85%

develop: 87%

Build Type

Pull #1495

github

Committed by ClemRz

Commit Message

fix(dbSync): add ORDER BY to paginated queries to prevent duplicates

Without ORDER BY, PostgreSQL does not guarantee stable row ordering
across LIMIT/OFFSET pages. This caused rows to appear multiple times
or be skipped entirely during Typesense index sync.

Ref: https://www.postgresql.org/docs/current/queries-limit.html

Pull Request Pull Request #1495: refactor(dbSync): improve logging and fix pagination ordering

Coverage Stats

2668 of 3289 branches covered (81.12%)

Branch coverage included in aggregate %.

1 of 17 new or added lines in 2 files covered. (5.88%)

3 existing lines in 2 files now uncovered.

5613 of 6422 relevant lines covered (87.4%)

33.32 hits per line