sql - Django Queryset __in 在列表中没有值

Question

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

你不认为那会是 IN (NULL, 1) ?

喜欢:

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

这是默认的 SQL 行为、django 错误还是我遗漏了 f__in= ?

先感谢您!

Answer 1

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