id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
10099	MySQL 5.0 does not support LIMIT in subqueries	Pavel Anossov	nobody	"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)
}}}"		closed	Database layer (models, ORM)	dev		wontfix		chris@…	Accepted	1	0	0	0	0	0