diff geo-backend/src/test/ressources/QueryExecutorTestCase.properties @ 269:db8920c5346d

Added further Queries for Testing Spatial-Query-Support geo-backend/trunk@220 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Wed, 14 Oct 2009 10:58:49 +0000
parents 000e00592ba5
children ff1b7967e6b9
line wrap: on
line diff
--- a/geo-backend/src/test/ressources/QueryExecutorTestCase.properties	Wed Oct 14 10:01:45 2009 +0000
+++ b/geo-backend/src/test/ressources/QueryExecutorTestCase.properties	Wed Oct 14 10:58:49 2009 +0000
@@ -34,4 +34,38 @@
           m.ZLOCATION IN (-16.843 , -15.852) AND \
           MSV.PARAMETERID in (2 , 1) \
      ORDER BY MSV.PARAMETERID, \
-              m.ZLOCATION
\ No newline at end of file
+              m.ZLOCATION
+              
+spatial_query_without_intersects2 = SELECT ST_ASTEXT(SHAPE), \
+           msv.DATAVALUE YORDINATE, \
+           msv.PARAMETERID GROUP1, \
+           msv.TIMEVALUE GROUP2, \
+           MEDIAN.MESHPOINT.KPOSITION GROUP3, \
+           MEDIAN.MESHPOINT.JPOSITION , \
+           MEDIAN.MESHPOINT.IPOSITION \
+    from MEDIAN.MESHLAYER ml, \
+         MEDIAN.MESHPOINT , \
+         MEDIAN.MESH m, \
+         MEDIAN.MESHSCALARVALUE msv \
+    where msv.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \
+          ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \
+          ml.MESHID = MEDIAN.MESHPOINT.MESHID and \
+          m.MESHID = MEDIAN.MESHPOINT.MESHID AND \
+          m.PARTIDMIN <= msv.PARTID AND \
+          m.PARTIDMAX >= msv.PARTID AND \
+          msv.PARAMETERID in (2,1) AND \
+          msv.TIMEVALUE in (to_date('2009.10.15 23:00:00', 'YYYY.MM.DD HH24:MI:SS')) AND \
+          m.OBJECTID = 3 AND \
+          MEDIAN.MESHPOINT.FEATUREID in \
+            ( select FEATUREID \
+              from MEDIAN.MESHPOINT mp, \
+                   MEDIAN.MESH m \
+              where m.OBJECTID = 3 AND \
+                    mp.MESHID = m.MESHID  AND \
+                    KPOSITION in ( 1 ) and \
+                    JPOSITION = (select JPOSITION from MEDIAN.MESHPOINT where FEATUREID = 2003771)) \
+   order by MEDIAN.MESHPOINT.KPOSITION, \
+            msv.TIMEVALUE, \
+            msv.PARAMETERID, \
+            MEDIAN.MESHPOINT.JPOSITION , \
+            MEDIAN.MESHPOINT.IPOSITION
\ No newline at end of file

http://dive4elements.wald.intevation.org