Bug #45451 Could not create spatial index

• Submitted: 11 Jun 2009 13:27
• Modified: 8 Aug 2012 9:09
• Reporter: charuta deo
• Status: Not a Bug
• Category: MySQL Server: GIS
• Severity: S1 (Critical)
• Version: 5.1
• OS: Any
• CPU Architecture: Any

[11 Jun 2009 13:27] charuta deo

Description:
hi,

I am trying to create SPATIAL INDEX on the column shape whose datatype is GEOMETRY. but i m getting following error while executing the query:

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

Ouery is:

create table Land (shape GEOMETRY not null);
alter table geom add  SPATIAL INDEX(shape);

Also i hav to load shape file into mysql table.

Kindly suggest some solution.

How to repeat:

whenever u are creating the spatial index.

[11 Jun 2009 13:46] Valeriy Kravchuk

Please, check (with SHOW CREATE TABLE, for example), that your table is MyISAM. If it is not error message is expected and documented. Read http://dev.mysql.com/doc/refman/5.1/en/create-index.html.

[11 Jul 2009 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[8 Aug 2012 9:09] Alexander Barkov

Most likely, an InnoDB table is created by default,
which does not support spatial indexes yet.
This is on TODO. Closing as no feedback privided.