[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: |
|
| 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 |