[Geoserver-devel] [jira] (GEOS-6414) WMS-T time range query incorrect

Chris Van Orman created an issue

GeoServer / BugGEOS-6414

WMS-T time range query incorrect

Issue Type:

BugBug

Affects Versions:

2.5

Assignee:

Andrea Aime

Attachments:

rangeQuery.patch

Components:

WMS

Created:

24/Mar/14 3:33 PM

Environment:

All

Priority:

MinorMinor

Reporter:

Chris Van Orman

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 [range] OR expiry_date BETWEEN [range]’. This does not handle the case when the given range parameter is entirely inside the effective_date and expiry_date.

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 <= [range.end] AND expiry_date >= [range.start]’.

Add Comment

Add Comment

This message was sent by Atlassian JIRA (v6.1.6#6162-sha1:7af547c)

Atlassian logo