mistype in -> Django 1.1 1.2 1.3 dev - QuerySet API reference - exclude(**kwargs)

[g1ra]

in documentation ​https://docs.djangoproject.com/en/1.3/ref/models/querysets/#exclude
end of the /exclude/ QuerySet refinement method
Django 1.0 is correct, but other version contains mistype.

Bad:

SELECT ...
WHERE NOT pub_date > '2005-1-3'
AND NOT headline = 'Hello'

Correct (in Django 1.0):

SELECT ...
WHERE NOT pub_date > '2005-1-3'
OR NOT headline = 'Hello'

[Claude Paroz]

Sorry, but your assertion seems wrong to me.

[g1ra]

SELECT ...
WHERE NOT (pub_date > '2005-1-3' AND headline = 'Hello')
is same as
SELECT ...
WHERE NOT pub_date > '2005-1-3'
AND NOT headline = 'Hello'

then
Entry.objects.exclude(pub_dategt=datetime.date(2005, 1, 3), headline='Hello')
is same as
Entry.objects.exclude(pub_dategt=datetime.date(2005, 1, 3)).exclude(headline='Hello')
???

[Claude Paroz]

To sum up IRC discussions on this subject, here are some tables:

Entry.objects.exclude(pub_date__gt=datetime.date(2005, 1, 3), headline='Hello')
SELECT ... WHERE NOT (pub_date > '2005-1-3' AND headline = 'Hello')

pub_date	headline	boolean result
2004-04-01	Hello	0 1 -> 0 -> 1
2006-04-01	Nice	1 0 -> 0 -> 1
2004-04-01	Blue	0 0 -> 0 -> 1
2006-04-01	Hello	1 1 -> 1 -> 0

Entry.objects.exclude(pub_date__gt=datetime.date(2005, 1, 3)).exclude(headline='Hello')
SELECT ... WHERE NOT pub_date > '2005-1-3' AND NOT headline = 'Hello'

pub_date	headline	boolean result
2004-04-01	Hello	0 1 -> 1 0 -> 0
2006-04-01	Nice	1 0 -> 0 1 -> 0
2004-04-01	Blue	0 0 -> 1 1 -> 1
2006-04-01	Hello	1 1 -> 0 0 -> 0

[Ramiro Morales]

Replying to g1ra:

SELECT ...

Please please please use the Preview option before posting ticket or comments to tickets. You've posted twice so far and in both ocassions what you've written is completely unreadable.