Defect #2221

Today filter fails on sqlite

Added by Alex Mankuta about 14 years ago. Updated about 14 years ago.

Status:ClosedStart date:2008-11-21
Priority:NormalDue date:
Assignee:-% Done:


Target version:0.8
Resolution:Fixed Affected version:


I use Redmine with sqlite and it has some issues with today filter. Basically it shows tomorrow issues but not today.

It looks like a bug in sqlite itself. The lower value is not tested for equality but higher is.

PS: I didn't check other date filters yet. Probably they need similar fixes too.

redmine-sqlite-today.patch Magnifier - Today patch for sqlite (786 Bytes) Alex Mankuta, 2008-11-21 12:04

Associated revisions

Revision 2054
Added by Jean-Philippe Lang about 14 years ago

Fixed date filters accuracy with SQLite (#2221).


#1 Updated by Jean-Philippe Lang about 14 years ago

  • Category changed from Search engine to Issues
  • Status changed from New to Closed
  • Target version set to 0.8
  • Affected version (unused) set to devel
  • Resolution set to Fixed

Actually, the fix was a bit more complex so that it works with Postgresql as well.
It should be fixed in r2054. Thanks for pointing out.

Also available in: Atom PDF