Changes between Version 22 and Version 23 of DevWikiEmptyGeometry

Timestamp:

Oct 6, 2009, 2:15:02 PM (15 years ago)

Author:

pramsey

Comment:

—

DevWikiEmptyGeometry

@@ -11 +11 @@
  * ST_Distance(geometry, empty) == NULL
  * ST_DWithin(geometry, empty, tolerance) == FALSE (if distance = null, shouldn't DWithin be null?)
- * ST_Contains(geometry, empty) == TRUE
- * ST_Within(geometry, empty) == FALSE
- * ST_Contains(empty, geometry) == FALSE
- * ST_Within(empty, geometry) == TRUE
+ * ST_Contains(geometry, empty) == FALSE (SQL Server says False)
+ * ST_Within(geometry, empty) == FALSE (SQL Server says False)
+ * ST_Contains(empty, geometry) == FALSE (SQL Server says False)
+ * ST_Within(empty, geometry) == FALSE  (SQL Server says False)
  * ST_Contains(empty, empty) == FALSE (SQL Server says False)
  * ST_Intersects(geometry, empty) == FALSE
@@ -115 +115 @@
   => 0
 
+SELECT Geometry::STGeomFromText('POINT(1 2)',4326).STContains(Geometry::STGeomFromText('POLYGON EMPTY',4326))
+       => 0
+
+--geometry within empty
+ SELECT Geometry::STGeomFromText('POINT(1 2)',4326).STWithin(Geometry::STGeomFromText('POLYGON EMPTY',4326))
+        => 0
+
+--empty contains geometry
+ SELECT Geometry::STGeomFromText('POLYGON EMPTY',4326).STContains(Geometry::STGeomFromText('POINT(1 2)',4326))
+ => 0
+
+ --empty within geometry
+SELECT Geometry::STGeomFromText('POLYGON EMPTY',4326).STWithin(Geometry::STGeomFromText('POINT(1 2)',4326))
+ => 0
 
 }}}