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
12236	When subquery returns more than 1 row MySQL leads to error	Ilya	nobody	"
Code something like:{{{ MyModel.objects.filter(key_to_mymodel2 = MyModel2.objects.all()))}}}
produce SQL query:
{{{ 
SELECT * FROM `test_mymodel` WHERE key_to_mymodel2_id =(select `id `from `test_mymodel2`)
}}}
It works fine on SQLLite, but in MySQL it cause an error {{{OperationalError: (1242, 'Subquery returns more than 1 row')}}}

For correct work of subquerys on MySQL need be added ANY ([ mysql errors]):
{{{
SELECT * FROM `test_mymodel` WHERE key_to_mymodel2_id = ANY (select
`id` from `test_mymodel2`)
}}}
"		closed	Database layer (models, ORM)	1.1		invalid			Unreviewed	0	0	0	0	0	0