Cannot set spatial index to geometry type - #1464

Asked Jun 06 '16 at 08:19

Active Jun 06 '16 at 08:20

Viewed 469 times

I use MySQL version 5.5.49. They type of the column is geometry and the engine of the table is InnoDB.

I try something like

ALTER TABLE geom ADD SPATIAL INDEX(field);

ALTER TABLE geom ADD SPATIAL INDEX table (field);

CREATE SPATIAL INDEX sp_index ON table(field);

and I get the error

#1464 - The used table type doesn't support SPATIAL indexes

Does this has to do with the engine of the table, the version of MySQL or am I missing something?

I read The used table type doesn't support SPATIAL indexes that is the engine that causes the problem. Do I really have to change the engine? InnoDB is more suitable for my needs.

edited May 23 '17 at 12:22

Community

asked Jun 06 '16 at 08:19

slevin

2

As far as mysql doc is concerned spatial index is supported in myIsam Engine.See http://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html – Web Artisan Jun 06 '16 at 08:25
1

Then upgrade your MySQL to v5.7.5 – Shadow Jun 06 '16 at 08:32
@Bikash P Thank you. Do you know which version support spatial data in innoDB? Thanks – slevin Jun 06 '16 at 08:33
@Shadow version Does 5.7.5 support spatial data and indexes in innoDB? – slevin Jun 06 '16 at 08:34
@slevin have you read the document linked by Bikash in the 1st comment? Because this is described in the 1st sentence there... – Shadow Jun 06 '16 at 08:38
@Shadow Thanks, I just noticed that. – slevin Jun 06 '16 at 08:52

0 Answers0