Bug #1771 GIS: issimple() return incorrect value
Submitted: 6 Nov 2003 10:57 Modified: 7 Aug 2012 13:01
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: GIS Severity:S4 (Feature request)
Version:4.1 OS:Any (any)
Assigned to: Assigned Account CPU Architecture:Any

[6 Nov 2003 10:57] Oleksandr Byelkin
Description:
issimple() return incorrect value or description in manual is wrong: 
@findex IsSimple() 
@c description_for_help_topic IsSimple 
@item IsSimple(g) 
Returns 1 if the geometry value @code{g} has no anomalous geometric points, 
such as self intersection or self tangency. @code{IsSimple()} returns 0 if the 
argument is not simple, and @minus{}1 if it is @code{NULL}. 
 
(may be I incorectly understand simplicity, but I think point should be 
simple) 

How to repeat:
! select issimple(MultiPoint(Point(3, 6), Point(4, 10))), issimple(Point(3, 
6)), 
! issimple(PolygonFromText('POLYGON((10 10,20 10,20 20,10 20,10 
10))')),issimple(GeometryFromText('POINT(1 4)')), 
issimple(AsWKB(GeometryFromText('POINT(1 4)'))); 
! issimple(MultiPoint(Point(3, 6), Point(4, 10)))       issimple(Point(3, 6))   
issimple(PolygonFromText('POLYGON((10 10,20 10,20 20,10 20,10 10))'))       
issimple(GeometryFromText('POINT(1 4)'))    
issimple(AsWKB(GeometryFromText('POINT(1 4)'))) 
! 0     0       0       0       0
[8 Nov 2003 7:17] Alexey Botchkov
This function isn't really implemented yet
It will be implemented along with the exact spatial functions
[7 Aug 2012 13:01] Alexander Barkov
This bug was earlier fixed in mysql-5.6.0.