ST_INTERSECTS() reports FALSE for touching objects in maria-5.3-gis

Bug #801470 reported by Philip Stoev
6
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)' ) ) ;

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.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.