WMS-T time range query incorrect

Description

Making a WMS call against a layer with an effective and expiry date using a TIME parameter with a range results in an incorrect filter. The filter built is 'effective_date BETWEEN

For example, given a feature with an effective_date of '2011-01' and a expiry_date of '2011-04'. A time range query of '2011-02/2011-03' returns no results when I would think it should.

I've included a patch that changes this logic to 'effective_date <=

Environment

None

Activity

Show:
codehaus
April 10, 2015, 3:51 PM

CodeHaus Comment From: aaime - Time: Sun, 27 Apr 2014 11:04:40 -0500
---------------------
<p>Someone needs to add a test in order for the patch to be committed.</p>

codehaus
April 10, 2015, 3:51 PM

CodeHaus Comment From: vanorman - Time: Wed, 30 Apr 2014 14:10:36 -0500
---------------------
<p>I made some adjustments to the existing tests to include this particular case. I also fixed some other issues I found with the tests in general (they were not fully checking the expected vs actual results).</p>

codehaus
April 10, 2015, 3:51 PM

CodeHaus Comment From: aaime - Time: Sun, 11 May 2014 12:00:19 -0500
---------------------
<p>Thanks, the patch looks good, I've applied it to master, 2.5.x and 2.4.x</p>

Andrea Aime
February 15, 2017, 11:48 AM

Mass closing all resolved issues not modified in the last 4 weeks

Assignee

Unassigned

Reporter

codehaus

Triage

None

Fix versions

Affects versions

Priority

Low
Configure