1. mysql> select version();
  2. +-----------+
  3. | version() |
  4. +-----------+
  5. | 5.7.1-m11 |
  6. +-----------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql> create table t1 (id int primary key auto_increment, g GEOMETRY NOT NULL) engine=innodb;
  10. Query OK, 0 rows affected (0.06 sec)
  11.  
  12. mysql> ALTER TABLE t1 ADD SPATIAL INDEX(g);
  13. ERROR 1464 (HY000): The used table type doesn't support SPATIAL indexes
  14.  
  15.  
  16.  
  17. mysql> select version();
  18. +------------+
  19. | version() |
  20. +------------+
  21. | 5.5.29-log |
  22. +------------+
  23. 1 row in set (0.02 sec)
  24.  
  25. mysql> create table t1 (id int primary key auto_increment, g GEOMETRY NOT NULL) engine=innodb;
  26. Query OK, 0 rows affected (0.03 sec)
  27.  
  28. mysql> ALTER TABLE t1 ADD SPATIAL INDEX(g);
  29. ERROR 1464 (HY000): The used table type doesn't support SPATIAL indexes