#10099: MySQL 5.0 does not support LIMIT in subqueries
---------------------------------------------------+------------------------
Reporter: Anossov | Owner: nobody
Status: new | Milestone:
Component: Database layer (models, ORM) | Version: SVN
Resolution: | Keywords:
Stage: Unreviewed | Has_patch: 0
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
---------------------------------------------------+------------------------
Comment (by kna...@yahoo.com):
Thanks for the quick response :-)
I reapplied the patch to get the traceback info for you:
http://dpaste.com/118722/
The query is pretty convoluted, here is where it breaks:
{{{
mediaobj = get_object_or_404(Media.objects.filter(name=media,
record__name=record,
record__collection__id__in=accessible_ids(request.user, Collection),
storage__id__in=accessible_ids(request.user, Storage)).distinct())
}}}
accessible_ids returns a query itself - please let me know if you need
more code.
--
Ticket URL: <http://code.djangoproject.com/ticket/10099#comment:7>
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
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
