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
28590	Quotes around filter string omitted in query __str__()	Aur Saraf	Adiyat Mubarak	"Very low severity, and probably easy pickings:

In various versions of Django, up to 1.11.5, with sqlite, on Windows:

{{{
class M(models.Model):
    field = models.CharField(max_length=10)
}}}

{{{
>>> from bug import models
>>> print models.M.objects.filter(field='I am a string, look at me').query.__str__()
SELECT ""bug_m"".""id"", ""bug_m"".""field"" FROM ""bug_m"" WHERE ""bug_m"".""field"" = I am a string, look at me
>>> models.M.objects.filter(field='I am a string, look at me')
<QuerySet []>
>>> from django.db import connection
>>> print connection.queries[-1]['sql']
SELECT ""bug_m"".""id"", ""bug_m"".""field"" FROM ""bug_m"" WHERE ""bug_m"".""field"" = 'I am a string, look at me' LIMIT 21
}}}

{{{
SELECT ""bug_m"".""id"", ""bug_m"".""field"" FROM ""bug_m"" WHERE ""bug_m"".""field"" = I am a string, look at me
SELECT ""bug_m"".""id"", ""bug_m"".""field"" FROM ""bug_m"" WHERE ""bug_m"".""field"" = 'I am a string, look at me' LIMIT 21
}}}

{{{
WHERE ""bug_m"".""field"" = I am a string, look at me
WHERE ""bug_m"".""field"" = 'I am a string, look at me'
}}}"	Bug	closed	Database layer (models, ORM)	1.11	Normal	duplicate			Unreviewed	0	0	0	0	0	0