On Wed, Jun 3, 2009 at 3:03 PM, Don Spaulding <donspauldin...@gmail.com>wrote:
>
> bump.
>
> Can anyone tell me if this looks like a bug in Django?
>
> On Jun 1, 6:12 pm, Don Spaulding <donspauldin...@gmail.com> wrote:
> > Hi all,
> >
> > I've got a quick use case that I think should work according to the
> > docs, but it's not. In this case, Domain objects have a reverse fkey
> > relation named "reports", and the Report model has an "updated"
> > field. I'd like to annotate and order Domains by the max value of
> > "updated" for all related reports. The following interactive session
> > shows the behavior pretty well.
> >
> > >>> qs =
> Domain.objects.annotate(last_updated=Max('reports__updated')).order_by('last_updated')
> > >>> qs.count()
> > 1577
> > >>> print qs[0].last_updated
> >
> > IndexError: list index out of range>>> qs.count()
> >
> > InternalError: current transaction is aborted, commands ignored until
> > end of transaction block
> >
> > >>> connection._rollback()
> >
> > If I drop off the order_by call, things appear to work again.
> >
> > >>> qs = Domain.objects.annotate(last_updated=Max('reports__updated'))
> > >>> qs.count()
> > 1577
> > >>> print qs[0].last_updated
> >
> > 2009-05-28 13:25:55.027600
> >
> > What am I missing here (besides a thorough understanding of
> > aggregation)?
> >
>
It looks like a bug in django at first glance. Out of curiosity what
version of Django is it, since it looks a tiny bit like an old bug with
queryset chaining, but I think that was fixed even before the first beta.
Alex
--
"I disapprove of what you say, but I will defend to the death your right to
say it." --Voltaire
"The people's good is the highest law."--Cicero
--~--~---------~--~----~------------~-------~--~----~
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+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
