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
32691	Performance regression in Exact lookup on BooleanField on MySQL.	Todor Velichkov	Roman Miroshnychenko	"When filtering on boolean field in Django 2.2 the SQL output would look like this:
{{{
    WHERE `mytable`.`myfield` = 1
}}}

in Django 3.2 the SQL changed to:
{{{
    WHERE `mytable`.`myfield`
}}}

The problem with the 2nd approach is that in mysql8 this field is not used in indexes anymore, causing a great performance degradation.

"	Cleanup/optimization	closed	Database layer (models, ORM)	3.2	Normal	fixed	bool, booleanfield, orm, sql, mysql	Adam Johnson Simon Charette Dan Strokirk	Ready for checkin	1	0	0	0	0	0