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
22023	.values() followed by defer() or only() results invalid data or crash	Jani Tiainen	wiget	"Given model

{{{
class MyModel(models.Model):
    field_a = models.CharField(max_length=100)
    field_b = models.IntegerField()
    field_c = models.TextField()
}}}

Query {{{ MyModel.objects.values().only('field_b') }}}
Returns totally incorrect set of fields

Query {{{ MyModel.objects.values().defer('field_b') }}}
Returns all fields but data is shifted starting from field_b

Query {{{ MyModel.objects.values('field_a').only('field_b') }}}
Results a crash due malformed SQL.

"	Bug	closed	Database layer (models, ORM)	dev	Normal	fixed	orm		Accepted	0	0	0	0	0	0