MySQL Forums
Forum List  »  GIS

Intersection() is not working in MySQL 5.6.12
Posted by: Mike McCutcheon
Date: October 08, 2013 06:11AM

Intersection() is documented in MySQL 5.6 but does not seem to work in MySQL 5.6.12 - MySQL Community Server (GPL).

See http://dev.mysql.com/doc/refman/5.6/en/functions-that-create-new-geometries-from-existing-ones.html#spatial-operators

Intersection() works fine in MySQL 5.1.43-snapshot20091222.

I have used the same Intersection() test script on two servers with the different versions of MySQL so I'm fairly certain that is true.

NB ST_Intersects() might be OK in 5.6 but that merely identifies whether there is an intersection or not, whereas Intersection() defines the geometry of the intersection ie the location of the intersecting point, line or polygon.

Any thoughts ?
Is anyone working on these GIS functions ?
Can someone please look at the Intersection() function in 5.6 and debug it ?
What timescale (if any) ?

I need to know the situation ASAP - even if it's bad news - so I can decide what migration direction to take. Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Intersection() is not working in MySQL 5.6.12
4603
October 08, 2013 06:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.