LPexportBug801466.xml
[MDEV-3619] LP:801466 - ST_INTERSECTION() returns invalid value on empty intersection 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: |
LPexportBug801466.xml
|
| 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. |
| Comments |
| Comment by Philip Stoev (Inactive) [ 2011-06-24 ] |
|
Re: ST_INTERSECTION() returns invalid value on empty intersection in maria-5.3-gis 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 ) ') )); |
| Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ] |
|
Launchpad bug id: 801466 |