id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
6026	strange behavior of exclude() and multiple fields	Michael Samoylov <michael.samoylov@…>	nobody	"{{{
class Consumer(models.Model):
    user = models.ForeignKey(User, core=True, editable=False)
    [skipped]

class Trip(models.Model):
    consumer = models.ForeignKey(Consumer, related_name='consumer', blank=True, null=True, editable=False)
    legacy = models.BooleanField(default=False)  # used to flag old-style trip
    [skipped]   
}}}
{{{
>>> for t in Trip.objects.exclude(legacy=True):
...     if t.legacy is True:
...         print t.id
...         break
...
>>> for t in Trip.objects.exclude(consumer__user__email__contains='@yahoo.com ', legacy=True):
...     if t.legacy is True:
...         print t.id
...         break
...
34933
>>> for t in Trip.objects.exclude(consumer__user__email__icontains='@yahoo.com', legacy=True):
...     if t.legacy is True:
...         print t.id
...         break
...
34933
>>> for t in Trip.objects.exclude (consumer__user__email__endswith='@yahoo.com', legacy=True):
...     if t.legacy is True:
...         print t.id
...         break
...
34933
>>> for t in Trip.objects.exclude(duration=1, legacy=True):
...     if t.legacy is True:
...         print t.id
...         break
...
>>>
>>> for t in Trip.objects.filter(consumer__user__email__endswith='@yahoo.com', legacy=False):
...     if t.legacy is True:
...         print t.id
...         break
...
>>>
>>> for t in Trip.objects.exclude(consumer__user__email__endswith='@yahoo.com').exclude(legacy=True):
...     if t.legacy is True:
...         print t.id
...         break
...
>>>
}}}"		closed	Database layer (models, ORM)	0.96		invalid			Unreviewed	0	0	0	0	0	0