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
26160	[offset:limit] doesn't do anything	Ivan Maslov	nobody	"Env: postresql on remote server, django==1.8.8, psycopg2==2.6.1

Models:

{{{
class ProjectUser(AbstractBaseUser, PermissionsMixin):
    # ...


class Transaction(models.Model):
    # ...
    sent_time = models.DateTimeField(default=timezone.now)
    user = models.ForeignKey(ProjectUser, null=True, default=None)

}}}

I trying to check it by shell (with sql dump):
u = models.ProjectUser.objects.get(id=1) # ok - this is my first project user
I see ""SELECT BLABLABLA WHERE BLABLA.""id"" = 1
After this:
tr = u.transaction_set.order_by('-sent_time')
tr.count()
I see ""SELECT COUNT(*) BLABLABLA FROM BLABLABLA = 1""
Out: 14 # 14 rows in the database

tr[0:10]
I see ""SELECT BLABLABLA DESC LIMIT 10"" and ten transactions into a queryset

And finally do:
tr[10:10]

And nothing.
Only [] in shell.

But if i will use a Paginator, it works correctly

{{{
list(paginator.page(2))
[<Transaction: Transaction object>,
 <Transaction: Transaction object>,
 <Transaction: Transaction object>,
 <Transaction: Transaction object>]
}}}

"	Bug	closed	Database layer (models, ORM)	1.8	Normal	invalid	offset, limit		Unreviewed	0	0	0	0	0	0