ST_INTERSECTS() reports FALSE for touching objects in maria-5.3-gis
Bug #801470 reported by
Philip Stoev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Undecided
|
Alexey Botchkov |
Bug 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)' ) ) ;
Related branches
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Alexey Botchkov (holyfoot) |
Changed in maria: | |
milestone: | 5.3 → none |
Changed in maria: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.