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
13261	SQL Update VS extra() or filter()	Stephane	nobody	"Hi,

I add one of this two filters on the query with a get_query_set() in a manager:
  * {{{qset = qset.filter(site=settings.SITE_ID)}}}
  * {{{qset = qset.extra(where=['site_id = %s' % settings.SITE_ID])}}}

All fine when I try to perform a SELECT, but when I do an UPDATE, the site_id are in the SET ({{{UPDATE ... SET site_id = 1 WHERE ...}}}) of the query and not in the WHERE ({{{UPDATE ... SET ... WHERE site_id = 1}}}).

Stéphane"		closed	Database layer (models, ORM)	dev		worksforme	sql update extra filter		Accepted	0	0	0	0	0	0