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 4333,Filtering date gt in SQLite returns identical objects,Michael Snoyman ,Adrian Holovaty,"I'm putting together a very simple blog app, and one feature I put in was to have a link to the next newer and older entries. Here's what (the relevant parts of) my model looks like: {{{ class Entry(models.Model): when = models.DateField(core=True) def newer(self): set = Entry.objects.filter(blogger=self.blogger).filter(when__gt=self.when) try: return set[0] except IndexError: return None def older(self): set = Entry.objects.filter(blogger=self.blogger).filter(when__lt=self.when) try: return set[0] except IndexError: return None }}} I run my site using MySQL, and things work properly (ie, for the newest entry, newer returns None, etc). On my test environment, I'm using SQLite. Older works properly; however, when viewing the newest entry, newer returns itself.",,closed,"Database layer (models, ORM)",dev,,invalid,sqlite date,,Unreviewed,0,0,0,0,0,0