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
12268	[PATCH] can't do %s on extra select	manuel@…	nobody	"There are times when you want to send to the database manager %s, an example of this usage would be converting from time string to epoch inside the database it self, for doing this you can use a line like: qs=qs.extra(select={'timestamp': ""strftime(\""%%s\"", time, 'utc')""})  (sqlite3).

Problem with this is that django detects %s in the select argument of extra and then waits for a select_params, unfortunately there's no escape been taken into account. The patch attached fixed this by detecting %%s as a valid escape sequence."	Bug	closed	Database layer (models, ORM)	dev	Normal	duplicate	select extra escape	anssi.kaariainen@…	Accepted	1	1	0	0	0	0