068: Ending date filter is non-inclusive - LeetCode.net

Notice: this is a static mirror for historical purposes.

View Issue Details [ Jump to Notes ] [ Related Changesets ]

[ Issue History ] [ Print ]

ID

Project

Category

View Status

Date Submitted

Last Update

068

Source Integration

Filters

public

2009-10-19 11:02

2009-10-19 11:10

Reporter

John Reese

Assigned To

John Reese

Priority

normal

Severity

major

Reproducibility

always

Status

resolved

Resolution

fixed

Product Version

0.14

Target Version

0.14

Fixed in Version

0.14

Summary

068: Ending date filter is non-inclusive

Description

When searching for changesets on a single day, setting starting and ending filters on the same date, no changesets are returned because the date strings generated are implicitly cast by the database to "XXXX-YY-ZZ 00:00:00:". The filter system should be enhanced to generate "XXXX-YY-ZZ 23:59:59" for the end date filter so that the given date is inclusive, while the start date generates "XXXX-YY-ZZ 00:00:00" so that it too can be inclusive.

Tags

No tags attached.

Relationships

Notes
(067) John Reese (administrator) 2009-10-19 11:10	Fix committed to master branch at 2009-10-19 18:02:33.

Related Changesets
Source Integration: master f9f65250 Timestamp: 2009-10-19 18:02:33 Author: John Reese Committer: John Reese [ Details ] [ Diff ]	Fix 068: End date filter is non-inclusive
	mod - Source/Source.FilterAPI.php		[ Diff ] [ File ]

Issue History
Date Modified	Username	Field	Change
2009-10-19 11:02	John Reese	New Issue
2009-10-19 11:02	John Reese	Status	new => assigned
2009-10-19 11:02	John Reese	Assigned To	=> John Reese
2009-10-19 11:10	John Reese	Note Added: 067
2009-10-19 11:10	John Reese	Status	assigned => resolved
2009-10-19 11:10	John Reese	Fixed in Version	=> 0.16
2009-10-19 11:10	John Reese	Resolution	open => fixed
2009-10-19 11:10	John Reese	Changeset attached	master f9f65250 =>

Copyright © 2000 - 2012 MantisBT Group

Time: 0.1121 seconds.
memory usage: 8,318 KB

Linode