#9358: .dates(...) only spitting out a single date, bug in queryset order
---------------------------------------------------+------------------------
Reporter: dokterbob | Owner: nobody
Status: new | Milestone: post-1.0
Component: Database layer (models, ORM) | Version: SVN
Resolution: | Keywords: dates
order .dates sqlite
Stage: Unreviewed | Has_patch: 1
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
---------------------------------------------------+------------------------
Comment (by dokterbob):
I am running sqlite-3.6.2 and pysqlite-2.4.1 on Gentoo prefix on Leopard.
About the patch: I agree with you that it shouldn't work, but for me it
does. Better than the original code.
Remembering from my SQL days, correct code would be something like:
{{{
SELECT DISTINCT django_date_trunc("day", "agenda_event"."event_date") AS
django_date FROM "agenda_event" ORDER BY django_date ASC
}}}
--
Ticket URL: <http://code.djangoproject.com/ticket/9358#comment:2>
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-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
