[Django] #12597: somefield__isnull=False produce wrong SQL

[Django]

#12597: somefield__isnull=False produce wrong SQL
-----------------------------+----------------------------------------------
Reporter: benc | Owner:
Status: new | Milestone:
Component: ORM aggregation | Version: 1.1
Keywords: | Stage: Unreviewed
Has_patch: 0 |
-----------------------------+----------------------------------------------
Hi

I have two models Model1 Model2, extending another model Model0(not
abstract).
I'm trying query Model0 and to filter only the models that have relation
to Model1

objects = list(Model0.objects.filter(model2__isnull=False)
which result with a SQL
WHERE "myapp_model0"."id" IS NOT NULL

objects = list(Model0.objects.filter(model2__isnull=True)
which result with a SQL
WHERE "myapp_model2"."model0_ptr_id" IS NULL'

The first SQL and the second is right.
When using ~Q to negate the second I get what I want.

Thanks

--
Ticket URL: <http://code.djangoproject.com/ticket/12597>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#12597: somefield__isnull=False produce wrong SQL

--------------------------------------+-------------------------------------
Reporter: benc | Owner:
Status: closed | Milestone:

Component: ORM aggregation | Version: 1.1

Resolution: duplicate | Keywords:
Stage: Unreviewed | Has_patch: 0
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
--------------------------------------+-------------------------------------
Changes (by russellm):

* status: new => closed
* needs_better_patch: => 0
* resolution: => duplicate
* needs_tests: => 0
* needs_docs: => 0

Comment:

Duplicate of #12598

--
Ticket URL: <http://code.djangoproject.com/ticket/12597#comment:1>