MySQL Forums
Forum List  »  GIS

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: POINT index is used in v5.7 but not in v8.0
1044
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.