We are effectively doing the following ORM query when generating the
recipients for e-mails:
target_people = (
review_request.target_people
.filter(is_active=True)
.filter(is_active=True)
)
which is (a) redundant and (b) seems to cause an incorrect query
result to occur on two of my machines, both running SQLite
3.25.2, which leads be to believe this is a bug in SQLite. In any
case, removing this second filter()
clause fixes the issue.
I have inspected the generated query and nothing seems out of place in
the query with two filters (besides the fact that its WHERE
clause
contains "auth_user"."is_active" = True
twice.