The used table type doesn't support SPATIAL indexes

Question

"The used table type doesn't support SPATIAL indexes"

I have got this error in MySQL when i am running a query which includes "contains" keyword. How to make a table support "SPATIAL indexes". The query is

select * from table where contains(column,"1")

Refer: http://dev.mysql.com/doc/refman/5.0/en/creating-spatial-indexes.html — Sathish D, Aug 22 '13 at 12:14

Micromega · Accepted Answer · 2013-08-22T17:42:43.350

10

Mysql support spatial index only with *.myisam tables, i.e. the ISAM engine. Link: http://dev.mysql.com/doc/refman/5.0/en/creating-spatial-indexes.html

edited Aug 22 '13 at 17:42

answered Aug 22 '13 at 12:02

Micromega

12,486
7
35
72

I created a Spatial Index on my table. Then changed the ENGINE to MYISAM with an Alter Table SQL. Then when I do EXPLAIN on my query I can still see that the Spatial index is unsed... – wheeleruniverse Mar 30 '18 at 13:36
What about mariaDB? – Sky Jan 02 '19 at 14:38

score 8 · Answer 2 · answered Jun 29 '16 at 09:43

8

Mysql support for spatial indexes firstly added for tables with MyISAM engine. Support for InnoDB engine added as of version 5.7.5.

MyISAM: >= 5.0
InnoDB: >= 5.7.5

answered Jun 29 '16 at 09:43

farzan

1,160
2
14
25

The used table type doesn't support SPATIAL indexes

2 Answers2

Linked