Changeset: b899b549728a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b899b549728a
Added Files:
geom/sql/functions/Tests/ST_Intersects.reqtest
geom/sql/functions/Tests/ST_Intersects.test
geom/sql/functions/Tests/loadTestPolygons.test
Modified Files:
geom/sql/functions/Tests/All
geom/sql/functions/Tests/createRTreeIndex.test
Branch: geo-update
Log Message:
Added test for ST_Intersects. Added test to add test polygons.
diffs (146 lines):
diff --git a/geom/sql/functions/Tests/All b/geom/sql/functions/Tests/All
--- a/geom/sql/functions/Tests/All
+++ b/geom/sql/functions/Tests/All
@@ -13,6 +13,7 @@ HAVE_GEOM?dropTestWKT
HAVE_GEOM?ST_MakePoint
HAVE_GEOM?ST_Collect
HAVE_GEOM?ST_MakeLine
+HAVE_GEOM?ST_Intersects
HAVE_GEOM?ST_IntersectsRTree
HAVE_GEOM?loadTestGeometries
diff --git a/geom/sql/functions/Tests/ST_Intersects.reqtest
b/geom/sql/functions/Tests/ST_Intersects.reqtest
new file mode 100644
--- /dev/null
+++ b/geom/sql/functions/Tests/ST_Intersects.reqtest
@@ -0,0 +1,1 @@
+loadTestPolygons
diff --git a/geom/sql/functions/Tests/ST_Intersects.test
b/geom/sql/functions/Tests/ST_Intersects.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/functions/Tests/ST_Intersects.test
@@ -0,0 +1,91 @@
+# Geometric Intersects
+
+## Point - Polygon
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_POINT(10,10)]
+ ST_INTERSECTS
+ [geom]
+----
+POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((10 10, 20 10, 10 20, 10 10))
+
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_POINT(15,10)]
+ ST_INTERSECTS
+ [geom]
+----
+POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((10 10, 20 10, 10 20, 10 10))
+
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_POINT(15,15)]
+ ST_INTERSECTS
+ [geom]
+----
+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_INTERSECTS
+ [geom]
+----
+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_INTERSECTS
+ [geom]
+----
+
+
+## Line - Polygon
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_GEOMFROMTEXT('LINESTRING (0 0, 15 15)')]
+ ST_INTERSECTS
+ [geom]
+----
+POLYGON ((10 10, 20 10, 20 20, 10 20, 10 10))
+POLYGON ((10 10, 20 10, 10 20, 10 10))
+
+query T rowsort
+SELECT
+ geom
+FROM geometries
+WHERE
+ [ST_GEOMFROMTEXT('LINESTRING(5 5, 10 15)')]
+ ST_INTERSECTS
+ [geom]
+----
+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))
+
diff --git a/geom/sql/functions/Tests/createRTreeIndex.test
b/geom/sql/functions/Tests/createRTreeIndex.test
--- a/geom/sql/functions/Tests/createRTreeIndex.test
+++ b/geom/sql/functions/Tests/createRTreeIndex.test
@@ -15,10 +15,3 @@ INSERT INTO geometries_rtree (geom) VALU
statement ok
SELECT mbr(geom) FROM geometries_rtree
-
-
-INSERT INTO geometries_rtree (geom) VALUES (ST_WKTToSQL('POLYGON((10 10, 20
10, 20 20, 10 20, 10 10))'));
-INSERT INTO geometries_rtree (geom) VALUES (ST_WKTToSQL('POLYGON((10 10, 20
10, 10 20, 10 10))'));
-INSERT INTO geometries_rtree (geom) VALUES (ST_WKTToSQL('POLYGON((10 20, 20
10, 20 20, 10 20))'));
-INSERT INTO geometries_rtree (geom) VALUES (ST_WKTToSQL('POLYGON((0 20, 10 20,
20 20, 20 10, 0 20))'));
-SELECT mbr(geom) FROM geometries_rtree;
diff --git a/geom/sql/functions/Tests/loadTestPolygons.test
b/geom/sql/functions/Tests/loadTestPolygons.test
new file mode 100644
--- /dev/null
+++ b/geom/sql/functions/Tests/loadTestPolygons.test
@@ -0,0 +1,14 @@
+statement ok
+CREATE TABLE geometries (id serial, geom geometry)
+
+statement ok
+INSERT INTO geometries (geom) VALUES (ST_WKTToSQL('POLYGON((10 10, 20 10, 20
20, 10 20, 10 10))'))
+
+statement ok
+INSERT INTO geometries (geom) VALUES (ST_WKTToSQL('POLYGON((10 10, 20 10, 10
20, 10 10))'))
+
+statement ok
+INSERT INTO geometries (geom) VALUES (ST_WKTToSQL('POLYGON((10 20, 20 10, 20
20, 10 20))'))
+
+statement ok
+INSERT INTO geometries (geom) VALUES (ST_WKTToSQL('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]
