Freegle / Iznik / 22415

71%

master: 71%

Build Type

Pull #812

circleci

Committed by edwh

Commit Message

Merge origin/master into fix/log-history-group-filter-9672-3

Resolve the GetUserMessageHistory conflict by combining both changes that
touch that query:
 - this PR (#812): replace the fan-out LEFT JOIN messages_postings with a
   correlated subquery (MAX(mp.date) filtered by groupid) so reposts no
   longer duplicate history rows and a group's arrival date isn't
   contaminated by another group's posting.
 - master (#805): keep the collection filter as IN (Approved, Pending) so
   pending posts still appear in member posting history.

The two changes are independent (arrival computation vs collection filter);
the merged query carries both. Appends this PR's two new tests after #805's
pending-history test; no helper collisions.

Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>

Pull Request Pull Request #812: fix(modtools): deduplicate member posting history when message has reposts (#9672)

Coverage Stats

10473 of 11990 branches covered (87.35%)

Branch coverage included in aggregate %.

9 of 9 new or added lines in 1 file covered. (100.0%)

1 existing line in 1 file now uncovered.

95894 of 136905 relevant lines covered (70.04%)

40.55 hits per line