changeset 196:60c61f323f16

Bugfix for TIMESERIESPOINT the first and the last value weren't used in the Query which was integrated from the Prototyp to the Project ussue54 gnv-artifacts/trunk@249 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 20 Oct 2009 10:07:22 +0000
parents 63f65fb9f210
children bab92ad1165d
files gnv-artifacts/src/test/ressources/queries.properties
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/gnv-artifacts/src/test/ressources/queries.properties	Mon Oct 19 13:33:36 2009 +0000
+++ b/gnv-artifacts/src/test/ressources/queries.properties	Tue Oct 20 10:07:22 2009 +0000
@@ -77,8 +77,8 @@
     WHERE tv.TIMESERIESID = t.TIMESERIESID AND \
           t.PARAMETERID IN ( ? ) AND \
           tv.MEASUREMENTID IN ( ? ) AND \
-          tv.TIMEVALUE > ? AND \
-          tv.TIMEVALUE < ? \
+          tv.TIMEVALUE >= ? AND \
+          tv.TIMEVALUE <= ? \
     ORDER BY tv.MEASUREMENTID , \
              tv.TIMESERIESID , \
              t.PARAMETERID , \

http://dive4elements.wald.intevation.org