Django Queryset __in no value in the list

Question

a = M.objects.filter(f__in=[None, 1])
a.query.__str__()
u'SELECT * FROM "app_m" WHERE "app_m"."f" IN (None, 1)'

Don't you think it will be IN (NULL, 1)?

as:

a = M.objects.filter(f=None)
a.query.__str__()
u'SELECT * FROM "app_m" WHERE "app_m"."f" IS NULL'

Is this the default SQL behavior, django error, or am I missing something using f__in=?

Thank you in advance!

+5

panchicore Mar 12 '13 at 15:50

2 answers

catherine · Answer 1 · 2013-03-12T16:24:22+0000

a = M.objects.filter(Q(f__isnull=True) | Q(f__in=['1',...]))

swK · Answer 2 · 2013-11-14T18:34:02+0000

There seems to be an old bug in Django ( https://code.djangoproject.com/ticket/13768 ).

I just ran a few tests with Django 1.5, and it still exists: "None" is ignored when used in a list applied to "__in" (no errors).

Katherine's approach works like a charm :)