Problem when retrieving objects with AND over multiple OR statements

[Haisheng HU]

I'm using Django 1.3 on MongoDB, and met a weird situation.

Project.objects.filter(

Q(owner=u'A') | Q(owner=u'B'),
Q(owner=u'C') | Q(owner=u'D'),

)

The above returned queryset is same to Project.objects.filter(Q(owner=u'C') | Q(owner=u'D')), but not None, as expected. It seems that the first half lookup function was omitted.

Does someone know that it's problem with Django or third-party mongodb-engine libraries? Thanks in ad!

[Aymeric Augustin]

It isn't a problem with Django:

>>> AutoName.objects.all()
[<AutoName: A>, <AutoName: C>]
>>> AutoName.objects.filter(Q(name=u'A') | Q(name=u'B'), Q(name=u'C') | Q(name=u'D'))
[]
>>> AutoName.objects.filter(Q(name=u'A') | Q(name=u'B'))
[<AutoName: A>]
>>> AutoName.objects.filter(Q(name=u'C') | Q(name=u'D'))
[<AutoName: C>]

(example with the models from ​https://bitbucket.org/aaugustin/django-tz-demo)

[Haisheng HU]

Thanks for your quick input. Then what is the related package? Any advice is appreciated!