#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):
I did some more research on this and I think I tracked in down to a change
between Django 1.0 and 1.1 - the QuerySet API reference
(http://docs.djangoproject.com/en/dev/ref/models/querysets/#in) has this
code example
{{{
inner_q = Blog.objects.filter(name__contains='Cheddar').values('pk').query
entries = Entry.objects.filter(blog__in=inner_q)
}}}
which does not seem to be valid in Django 1.1 anymore.
It still seems to work though if this patch is not applied to the Django
codebase, so I did not notice this change before.
I'll rewrite my code according to the latest documentation and see if it
works - apologies for anybody's wasted time.
--
Ticket URL: <http://code.djangoproject.com/ticket/10099#comment:9>
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
-~----------~----~----~----~------~----~------~--~---
