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
12656	QuerySet.defer in default Manager breaks batch update (w/mysql?)	Ben Jackson	nobody	"I have an object with a large, infrequently used textfield.  I created a manager that defers that field since I do generate pages where I retrieve hundreds of those objects and I didn't want to spread defer() around everywhere.

This seems to break qs.update().  I have a ModelAdmin class that adds an option to globally set/unset a boolean.  When I invoke it on the class with the modified manager I get mysql syntax error:

(1064, ""You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `coverage_coverage` U0 INNER JOIN `coverage_run` U1 ON (U0.`run_id` = U1.`i' at line 1"")

Strangely this only happens if I first do a search from the admin interface and select from the search result.  The code appears to simply do 'id in selected' so I'm not sure why the prior search would matter.

If this does not leap out as an 'aha' for someone I can try to distill a minimal case.

(version 1.1.1)"	Uncategorized	closed	Database layer (models, ORM)	1.1	Normal	worksforme	defer		Unreviewed	0	0	0	0	0	0