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
14648	Annotated date querysets fail if spatial backend is used	codysoyland	jbronn	"Annotated DateQuerysets fail if django.contrib.gis is installed. By that I mean this queryset will throw an exception:

{{{
Bug.objects.annotate(num_patches=Count('patches')).dates('created', 'year')
}}}

Note that I'm not intentionally running dates() on an annotated queryset (that would normally be pointless); this is happening inside the date_based.archive_index generic view and I need the aggregate annotation in the main queryset.

My example project at https://github.com/codysoyland/django-gis-bug-example/ demonstrates this.
See the tests: https://github.com/codysoyland/django-gis-bug-example/blob/master/bughouse/tests.py

The test output is:

{{{
======================================================================
ERROR: test_date_queryset (bughouse.tests.DateQuerysetTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/Users/csoyland/projects/buggy/bughouse/tests.py"", line 19, in test_date_queryset
    len(Bug.objects.annotate(num_patches=Count('patches')).dates('created', 'year')),
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/db/models/query.py"", line 81, in __len__
    self._result_cache = list(self.iterator())
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/db/models/sql/compiler.py"", line 948, in results_iter
    for rows in self.execute_sql(MULTI):
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/db/models/sql/compiler.py"", line 717, in execute_sql
    sql, params = self.as_sql()
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/db/models/sql/compiler.py"", line 56, in as_sql
    out_cols = self.get_columns(with_col_aliases)
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/contrib/gis/db/models/sql/compiler.py"", line 78, in get_columns
    for alias, aggregate in self.query.aggregate_select.items()
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/contrib/gis/db/models/sql/compiler.py"", line 205, in get_extra_select_format
    if alias in self.query.custom_select:
AttributeError: 'DateQuery' object has no attribute 'custom_select'
}}}

Adding the GeoManager to this model results in a different error:

{{{
======================================================================
ERROR: test_date_queryset (bughouse.tests.DateQuerysetTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/Users/csoyland/projects/buggy/bughouse/tests.py"", line 19, in test_date_queryset
    len(Bug.objects.annotate(num_patches=Count('patches')).dates('created', 'year')),
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/db/models/query.py"", line 81, in __len__
    self._result_cache = list(self.iterator())
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/db/models/sql/compiler.py"", line 952, in results_iter
    date = self.resolve_columns(row, fields)[offset]
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/contrib/gis/db/models/sql/compiler.py"", line 192, in resolve_columns
    for v, a in izip(row[rn_offset:index_start], aliases)]
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/db/models/sql/query.py"", line 305, in convert_values
    return connection.ops.convert_values(value, field)
  File ""/Users/csoyland/.virtualenvs/generic/lib/python2.6/site-packages/django/db/backends/__init__.py"", line 441, in convert_values
    internal_type = field.get_internal_type()
AttributeError: 'NoneType' object has no attribute 'get_internal_type'
}}}"	Bug	closed	GIS	1.2	Normal	fixed		me@…	Accepted	1	0	1	1	0	0