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
2008	Negative offset in DB query set array-slicing fails silently	olau@…	Adrian Holovaty	"Ordinary Python array-slicing allows negative offsets to indicate accessing items from the end of an array, e.g.
{{{
l = [""foo"", ""bar"", ""baz""]
l[-1] <- returns ""baz""
l[-2] <- returns ""bar""
}}}

The same apparently does not work for querysets if they are not evaluated. Instead it fails silently. I've looked up the reference for select statements in SQLite and MySQL without finding anything obvious to remedy the problem, other than to reverse the ordering if present. But at least Django should give an error and not fail silently.

I'm using the syntax to extract the first and the last item of a sequence to summarize a larger set of items."	defect	closed	Database layer (models, ORM)	dev	normal	fixed			Unreviewed	0	0	0	0	0	0