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 21703 `exclude` query with `F` object across relationship fails anonymous nobody "Given the following models.. {{{ #!div style=""font-size: 80%"" Code highlighting: {{{#!python class Owner(models.Model): pass class Thing(models.Model): owner = models.ForeignKey(Owner, related_name='things') date = models.DateField() class Error(models.Model): owner = models.ForeignKey(Owner, related_name='errors') date = models.DateField() }}} }}} The following `exclude` query fails. {{{ #!div style=""font-size: 80%"" Code highlighting: {{{#!python >>> Error.objects.exclude(owner__things__date=F('date')) Traceback (most recent call last): File """", line 1, in File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/models/query.py"", line 115, in __repr__ data = list(self[:REPR_OUTPUT_SIZE + 1]) File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/models/query.py"", line 140, in __iter__ self._fetch_all() File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/models/query.py"", line 962, in _fetch_all self._result_cache = list(self.iterator()) File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/models/query.py"", line 264, in iterator for row in compiler.results_iter(): File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/models/sql/compiler.py"", line 681, in results_iter for rows in self.execute_sql(MULTI): File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/models/sql/compiler.py"", line 762, in execute_sql cursor.execute(sql, params) File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/backends/utils.py"", line 77, in execute return super(CursorDebugWrapper, self).execute(sql, params) File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/backends/utils.py"", line 61, in execute return self.cursor.execute(sql, params) File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/utils.py"", line 93, in __exit__ six.reraise(dj_exc_type, dj_exc_value, traceback) File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/backends/utils.py"", line 61, in execute return self.cursor.execute(sql, params) File ""/Users/foobar/python-environments/358426a27f281ff5/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py"", line 489, in execute return Database.Cursor.execute(self, query, params) OperationalError: no such column: U1.id }}} }}} The same query using a `filter` works as expected. This bug is present in `1.5.5`, `1.6.1` and `1.7.dev20131229181725`" Bug closed Database layer (models, ORM) 1.6 Normal fixed Accepted 0 0 1 0 0 0