[MDEV-3394] LP:801470 - ST_INTERSECTS() reports FALSE for touching objects in maria-5.3-gis Created: 2011-06-24  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Philip Stoev (Inactive) Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug801470.xml    

 Description   

If two objects are touching, ST_INTERSECTS() reports false and ST_INTERSECTION() reports an empty value.

By contrast, the postgis documentation says:

Overlaps, Touches, Within all imply spatial intersection. If any of the aforementioned returns true, then the geometries also spatially intersect.

In postgis, ST_INTERSECTS() will return TRUE and ST_INTERSECTION() will return a POINT

examples:

SELECT ST_CONTAINS( GeometryFromText(' POLYGON(( 1 1 , 1 9 , 9 1 , 9 9 , 1 1 )) ') , PointFromText(' POINT(1 1)' ) ) ;

SELECT ST_INTERSECTS( GeometryFromText(' LINESTRING( 3 3 , 3 0 ) ') , PointFromText(' POINT(3 0)' ) ) ;



 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 801470

Generated at Thu Feb 08 06:48:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.