ST_INTERSECTION() returns invalid value on empty intersection in maria-5.3-gis

Bug #801466 reported by Philip Stoev on 2011-06-24
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
Undecided
Alexey Botchkov

Bug Description

If two geometries do not intersect, ST_INTERSECTION() returns a value of length 4 that is not readable with AsText(). AsText() returns NULL.

PostGIS returns a value that ST_AsEWKT() interprets as GEOMETRYCOLLECTION EMPTY.

Philip Stoev (pstoev-askmonty) wrote :

Test case:

 SELECT AsText(ST_INTERSECTION( LinestringFromText(' LINESTRING( 1 1, 2 2 ) ') , GeometryFromText(' LINESTRING( 3 3 , 4 4 ) ') ));

postgis:

SELECT ST_AsEWKT(ST_INTERSECTION( EndPoint( LinestringFromText(' LINESTRING( 8 1 , 7 8 ) ') ) , GeometryFromText(' LINESTRING( 7 7 , 0 7 ) ') ));

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  Edit
Everyone can see this information.

Other bug subscribers