Defect #2221
Today filter fails on sqlite
| Status: | Closed | Start date: | 2008-11-21 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | - | % Done: | 0% | |
| Category: | Issues | |||
| Target version: | 0.8 | |||
| Resolution: | Fixed | Affected version: |
Description
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 
- Today patch for sqlite
(786 Bytes)
Associated revisions
Fixed date filters accuracy with SQLite (#2221).
History
#1
Updated by Jean-Philippe Lang almost 13 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.