Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Apr 24th, 2013  |  syntax: None  |  size: 0.76 KB  |  views: 42  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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
clone this paste RAW Paste Data