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
3962	sqlite3 backend does not allow '%i' in cursor.execute	anonymous	Adrian Holovaty	"In file /usr/lib/python2.4/site-packages/django/db/backends/sqlite3/base.py is sais:
{{{
def convert_query(self, query, num_params):
    return query % tuple(""?"" * num_params)
}}}

This raises a TypeError in cases like: ""SELECT * FROM table WHERE id = %i"" % tuple(""?"" * 1), because '?' is no int.

A workaround for this special case could be
{{{
return query.replace('%i', '%s') % tuple(""?"" * num_params)
}}}"		closed	Database layer (models, ORM)	dev		invalid	sqlite int integer %i		Unreviewed	1	0	0	0	0	0