Changeset: d73d831a6364 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d73d831a6364
Added Files:
geom/sql/functions/Tests/ST_DWithinRTree.reqtest
geom/sql/functions/Tests/ST_DWithinRTree.test
Branch: geo-update
Log Message:
Added ST_DwithinRTree test.
diffs (107 lines):
diff --git a/geom/sql/functions/Tests/ST_DWithinRTree.reqtest
b/geom/sql/functions/Tests/ST_DWithinRTree.reqtest
new file mode 100644
--- /dev/null
+++ b/geom/sql/functions/Tests/ST_DWithinRTree.reqtest
@@ -0,0 +1,1 @@
+createRTreeIndex
diff --git a/geom/sql/functions/Tests/ST_DWithinRTree.test
b/geom/sql/functions/Tests/ST_DWithinRTree.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/functions/Tests/ST_DWithinRTree.test
@@ -0,0 +1,96 @@
+# Geometric Intersects RTree
+
+## Point - Polygon
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_POINT(10,10)]
+ ST_DWITHIN
+ [geom, 5]
+----
+POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((10 10, 20 10, 10 20, 10 10))
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
+
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_POINT(15,10)]
+ ST_DWITHIN
+ [geom,5]
+----
+POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((10 10, 20 10, 10 20, 10 10))
+POLYGON ((10 20, 20 10, 20 20, 10 20))
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
+
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_POINT(15,15)]
+ ST_DWITHIN
+ [geom,0]
+----
+POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((10 10, 20 10, 10 20, 10 10))
+POLYGON ((10 20, 20 10, 20 20, 10 20))
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
+
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_POINT(17.5,17.5)]
+ ST_DWITHIN
+ [geom,2]
+----
+POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((10 20, 20 10, 20 20, 10 20))
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
+
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_POINT(5,15)]
+ ST_DWITHIN
+ [geom,3]
+----
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
+
+## Line - Polygon
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_GEOMFROMTEXT('LINESTRING (0 0, 15 15)')]
+ ST_DWITHIN
+ [geom,0]
+----
+POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((10 10, 20 10, 10 20, 10 10))
+POLYGON ((10 20, 20 10, 20 20, 10 20))
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
+
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_GEOMFROMTEXT('LINESTRING(5 5, 10 15)')]
+ ST_INTERSECTS
+ [geom,4]
+----
+POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((10 10, 20 10, 10 20, 10 10))
+POLYGON ((10 20, 20 10, 20 20, 10 20))
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
