#10099: MySQL 5.0 does not support LIMIT in subqueries
------------------------------------------+---------------------------------
Reporter: Anossov | Owner: nobody
Status: new | Milestone:
Component: Database layer (models, ORM) | Version: SVN
Keywords: | Stage: Unreviewed
Has_patch: 0 |
------------------------------------------+---------------------------------
As "in" lookup with querysets uses subqueries, it will create a subquery
with limit with a sliced queryset. MySQL 5.0 does not support it:
{{{
>>> User.objects.filter( group__in = Group.objects.all()[:5] ) # SELECT
(...) FROM `users` WHERE `users`.`group_id` IN (SELECT U0.`id` FROM
`groups` U0 LIMIT 5)
...
NotSupportedError: (1235, "This version of MySQL doesn't yet support
'LIMIT & IN/ALL/ANY/SOME subquery'")
>>> django.db.connection.get_server_version()
(5, 0, 67)
}}}
--
Ticket URL: <http://code.djangoproject.com/ticket/10099>
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
-~----------~----~----~----~------~----~------~--~---
