mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.1-m11 |
+-----------+
1 row in set (0.00 sec)
mysql> create table t1 (id int primary key auto_increment, g GEOMETRY NOT NULL) engine=innodb;
Query OK, 0 rows affected (0.06 sec)
mysql> ALTER TABLE t1 ADD SPATIAL INDEX(g);
ERROR 1464 (HY000): The used table type doesn't support SPATIAL indexes
mysql> select version();
+------------+
| version() |
+------------+
| 5.5.29-log |
+------------+
1 row in set (0.02 sec)
mysql> create table t1 (id int primary key auto_increment, g GEOMETRY NOT NULL) engine=innodb;
Query OK, 0 rows affected (0.03 sec)
mysql> ALTER TABLE t1 ADD SPATIAL INDEX(g);
ERROR 1464 (HY000): The used table type doesn't support SPATIAL indexes