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

[Philip Stoev]

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)]

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 ) ') ));