MySQL Forums
Forum List  »  GIS

Advanced Search
New Topic

Re: POINT index is used in v5.7 but not in v8.0
Posted by: Norvald Ryeng
Date: June 12, 2018 01:18AM

MySQL 8.0 will ignore spatial indexes on columns that are not restricted to one SRID. Here's a blog post explaining how it works: https://mysqlserverteam.com/geographic-indexes-in-innodb/

If you have a database in 5.7 you want to upgrade to 8.0, please also read https://mysqlserverteam.com/upgrading-spatial-indexes-to-mysql-8-0/ for some specific upgrade advice.

I also notice that the query uses SRID 4326. SRID 4326 has axis order latitude-longitude, but I suspect that the linestring is specified in longitude-latitude order (i.e., it's in the Netherlands, not the Arabian Sea). This blog post explains how to deal with axis order: https://mysqlserverteam.com/axis-order-in-spatial-reference-systems/

Best regards,

Norvald H. Ryeng

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
POINT index is used in v5.7 but not in v8.0
1635
J C
June 11, 2018 07:32AM
Re: POINT index is used in v5.7 but not in v8.0
929
Norvald Ryeng
June 12, 2018 01:18AM


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.