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
30942	first() and last() return same object (first in both cases) when the order_by field is the same	Tadas	nobody	"from datetime import datetime
from django.db import models

class Foo(models.Model):
    val = models.IntegerField()
    created_time = models.DateTimeField()

created_time = datetime.now()

foo1, _ = Foo.objects.get_or_create(val=1, defaults=dict(created_time=created_time))
foo2, _ = Foo.objects.get_or_create(val=2, defaults=dict(created_time=created_time))

assert Foo.objects.count() == 2

foos = Foo.objects.all().order_by('created_time')
print(foos.first().val, foos.last().val)  # prints -> 1 1

assert foo1.val == foos.first().val
assert foo2.val == foos.last().val  # FAILS"	Bug	closed	Database layer (models, ORM)	2.2	Normal	duplicate			Unreviewed	0	0	0	0	0	0