Why .filter() in django returns duplicated objects?

Question

I've followed django tutorial and arrived at tutorial05.

I tried to not show empty poll as tutorial says, so I added filter condition like this:

class IndexView(generic.ListView):
    ...
    def get_queryset(self):
        return Question.objects.filter(
            pub_date__lte=timezone.now(),
            choice__isnull=False
        ).order_by('-pub_date')[:5]

But this returned two objects which are exactly same.

I think choice__isnull=False caused the problem, but not sure.

Answer 1

choice__isnull causes the problem. It leads to join with choice table (to weed out questions without choices), that is something like this:

SELECT question.*
  FROM question
  JOIN choice
    ON question.id = choice.question_id
 WHERE question.pub_date < NOW()

You can inspect query attribute of QuerySet to be sure. So if you have one question with two choices, you will get that question two times. You need to use distinct() method in this case: queryset.distinct().

Answer 2

Just use .distinct() at the end of your ORM.