Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement