off by one calendar day when using create_date in search
Bug #1241024 reported by
Jason Etheridge
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Confirmed
|
Low
|
Mike Rylander |
Bug Description
In the TPAC, entering a search like this:
create_
will produce SQL that includes a clause like this:
AND bre.create_date BETWEEN $_24259$
So we're actually omitting records created on 2013-10-15, which goes against expectations.
Changed in evergreen: | |
milestone: | 2.5.0 → 2.5.1 |
Changed in evergreen: | |
milestone: | 2.5.1 → 2.5.2 |
Changed in evergreen: | |
milestone: | 2.5.2 → 2.6.0-alpha1 |
Changed in evergreen: | |
milestone: | 2.6.0-alpha1 → 2.6.0-beta1 |
Changed in evergreen: | |
milestone: | 2.6.0-beta1 → 2.6.0-rc1 |
Changed in evergreen: | |
milestone: | 2.6.0-rc1 → none |
milestone: | none → 2.next |
no longer affects: | evergreen/2.4 |
Changed in evergreen: | |
milestone: | 2.7.1 → 2.7.2 |
Changed in evergreen: | |
milestone: | 2.7.2 → 2.7.3 |
no longer affects: | evergreen/2.5 |
no longer affects: | evergreen/2.6 |
To post a comment you must log in.
This seems to fix it in my tests:
http:// git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/collab/ senator/ bre_dates_ not_timestamps