#14766: ordering by a field that does not exists returns an empty QuerySet
---------------------------------------------------+------------------------
Reporter: robhudson | Owner: nobody
Status: reopened | Milestone:
Component: Database layer (models, ORM) | Version: 1.2
Resolution: | Keywords: order_by
Stage: Unreviewed | Has_patch: 0
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
---------------------------------------------------+------------------------
Changes (by d0ugal):
* status: closed => reopened
* resolution: worksforme =>
Comment:
FWIW after speaking to Rob on irc I tried and I can reproduce with this.
Although, interestingly adding a count at the end makes the query "work."
{{{
In [5]: import django
In [6]: django.VERSION
Out[6]: (1, 2, 3, 'final', 0)
In [7]: from django.contrib.contenttypes.models import ContentType
In [8]: ContentType.objects.order_by('monkeys')
Out[8]: []
In [9]: ContentType.objects.order_by('monkeys').count()
Out[9]: 20
}}}
Using the mysql backend. I also tried on 1.1.1 with the same results
(albeit a different project).
--
Ticket URL: <http://code.djangoproject.com/ticket/14766#comment:5>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
