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
7232	unexpected results and incorrectly generated SQL using OneToOne models and Postgres	andrew@…	nobody	"I have been trying to select all the objects that do not have an associated OneToOne field. 
 * M.objects.filter fails to select the correct objects - either selects everything or nothing.
 * M.objects.exclude generates incorrect SQL - missing the table name, eg:
{{{
Failed example:
    Place.objects.exclude(restaurant__isnull=True)
Exception raised:
    Traceback (most recent call last):
      File ""/usr/local/lib/python2.5/site-packages/django/test/_doctest.py"", line 1267, in __run
        compileflags, 1) in test.globs
      File ""<doctest modeltests.one_to_one.models.__test__.API_TESTS[41]>"", line 1, in <module>
        Place.objects.exclude(restaurant__isnull=True)
      File ""/usr/local/lib/python2.5/site-packages/django/db/models/query.py"", line 43, in __repr__
        return repr(list(self))
      File ""/usr/local/lib/python2.5/site-packages/django/db/models/query.py"", line 55, in __len__
        self._result_cache.extend(list(self._iter))
      File ""/usr/local/lib/python2.5/site-packages/django/db/models/query.py"", line 162, in iterator
        for row in self.query.results_iter():
      File ""/usr/local/lib/python2.5/site-packages/django/db/models/sql/query.py"", line 200, in results_iter
        for rows in self.execute_sql(MULTI):
      File ""/usr/local/lib/python2.5/site-packages/django/db/models/sql/query.py"", line 1466, in execute_sql
        cursor.execute(sql, params)
    ProgrammingError: syntax error at or near ""WHERE""
    LINE 1: ...N (SELECT ""one_to_one_restaurant"".""place_id"" FROM WHERE ""one...
}}}

The following are additional cases for the unit tests in modeltests/one_to_one/models.py:
{{{
>>> p3 = Place.objects.create(name=""Not A Restaurant"", address=""123 Fake St"")
>>> Place.objects.filter(restaurant__exact=None)
[<Place: Not A Restaurant the place>]
>>> Place.objects.filter(restaurant__isnull=True)
[<Place: Not A Restaurant the place>]
>>> Place.objects.filter(restaurant__isnull=False)
[<Place: Demon Dogs the place>, <Place: Ace Hardware the place>]
>>> Place.objects.exclude(restaurant__isnull=True)
[<Place: Demon Dogs the place>, <Place: Ace Hardware the place>]
>>> Place.objects.exclude(restaurant__isnull=False)
[<Place: Not A Restaurant the place>]
}}}

I am using Ubuntu 7.10, Python 2.5.1, post QSRF Trunk Django, and Postgres 8.1
"		closed	Database layer (models, ORM)	dev		fixed	qsrf-cleanup		Unreviewed	0	0	0	0	0	0