Query Builder forgets annotations

Hi,

It seems the query builder forgets annotations when dealing with joins:

I have this model with Postgresql, Django 1.3 alpha 1 (SVN rev. 15659):

class Corporation(Model):
uuid = UuidField(primary_key=True)

class Branch(Model):
uuid = UuidField(primary_key=True)
corporation = ForeignKey(Corporation, related_name='branches')

Now I want to retrieve the corporations ordered by the number of their
branches:
Corporation.objects.annotate(x=Count('branches')).order_by('x')

Which fails with:
FieldError: Cannot resolve keyword 'x' into field. Choices are:
branches, uuid in /django/db/models/sql/query.py in setup_joins, line 1236

This
Corporation.objects.annotate(x=Count('branches'))
yields
SELECT corporation.uuid, COUNT(branch.uuid) AS x FROM corporation LEFT
OUTER JOIN branch ON (corporation.uuid = branch.corporation_id) GROUP BY
corporation.uuid, corporation.uuid

and executing this query manually, with `ORDER BY x` added, gives me
what I want.

Is this a django bug, or by design?

Now until this is fixed, how can I add this manually to the generated
statement? extra(order_by=['x']) also checks fields. But I don't want to
have to resort to completely raw queries…

Cheers,

--
Pascal Germroth

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.