Changeset: 8058d2e80012 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8058d2e80012
Modified Files:
geom/sql/functions/Tests/ST_DWithinRTree.test
Branch: default
Log Message:
Fixes row ordering and typos in ST_SDwithinRTree
diffs (113 lines):
diff --git a/geom/sql/functions/Tests/ST_DWithinRTree.test
b/geom/sql/functions/Tests/ST_DWithinRTree.test
--- a/geom/sql/functions/Tests/ST_DWithinRTree.test
+++ b/geom/sql/functions/Tests/ST_DWithinRTree.test
@@ -4,61 +4,61 @@
query T rowsort
SELECT
geom
-FROM geometries
+FROM geometries_rtree
WHERE
[ST_POINT(10,10)]
ST_DWITHIN
[geom, 5]
----
-POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
POLYGON ((10 10, 20 10, 10 20, 10 10))
-POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
+POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
query T rowsort
SELECT
geom
-FROM geometries
+FROM geometries_rtree
WHERE
[ST_POINT(15,10)]
ST_DWITHIN
[geom,5]
----
-POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
POLYGON ((10 10, 20 10, 10 20, 10 10))
+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
+FROM geometries_rtree
WHERE
[ST_POINT(15,15)]
ST_DWITHIN
[geom,0]
----
-POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
POLYGON ((10 10, 20 10, 10 20, 10 10))
+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
+FROM geometries_rtree
WHERE
[ST_POINT(17.5,17.5)]
ST_DWITHIN
[geom,2]
----
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
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
+FROM geometries_rtree
WHERE
[ST_POINT(5,15)]
ST_DWITHIN
@@ -70,27 +70,28 @@ POLYGON ((0 20, 10 20, 20 20, 20 10, 0 2
query T rowsort
SELECT
geom
-FROM geometries
+FROM geometries_rtree
WHERE
[ST_GEOMFROMTEXT('LINESTRING (0 0, 15 15)')]
ST_DWITHIN
[geom,0]
----
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
+POLYGON ((10 10, 20 10, 10 20, 10 10))
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
+FROM geometries_rtree
WHERE
[ST_GEOMFROMTEXT('LINESTRING(5 5, 10 15)')]
- ST_INTERSECTS
+ ST_DWITHIN
[geom,4]
----
+POLYGON ((0 20, 10 20, 20 20, 20 10, 0 20))
+POLYGON ((10 10, 20 10, 10 20, 10 10))
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]
