Athletics rosters are inconsistent

• Steps to reproduce
  • GET athletics/roster with no parameters.
  • GET athletics/teams/{team_id}/roster.
• Expected: Both endpoints return the same number of students for the same team.
• Actual: athletics/roster sometimes returns fewer students for the same team.

The results of a test are shown in the table below.

• Methodology
  • 5 schools were selected.
  • 3 athletics teams were randomly selected from each school.
  • Team rosters were fetched using both:
    • GET athletics/roster
    • GET athletics/teams/{team_id}/roster
  • The actual number of students returned by each endpoint was summed. (“count” properties were ignored.)
  • The difference between the two student counts was calculated.
• Results
  • Schools 1 and 3: The endpoints returned the same number of students for the randomly selected teams.
  • Schools 2, 4, and 5: The athletics/roster endpoint returned fewer students for three teams.

The differences are highlighted below.

Note: The test didn't check whether the same students are returned by both endpoints, only whether the counts matched.