Details
Description
server returns random column type
describe geozone;
|
polygon | polygon | NO | | NULL | | |
describe geozone;
|
polygon | geometry | NO | | NULL | | |
CREATE TABLE `geozone` ( |
`id` int(11) NOT NULL, |
`name` varchar(255) NOT NULL, |
`user_id` int(11) NOT NULL COMMENT 'creator', |
`active` tinyint(4) DEFAULT '1', |
`ride_end` tinyint(1) DEFAULT NULL COMMENT 'Jestli se v teto oblasti ma ukoncit jizda', |
`min_lat` double DEFAULT NULL, |
`min_lon` double DEFAULT NULL, |
`max_lat` double DEFAULT NULL, |
`max_lon` double DEFAULT NULL, |
`polygon` geometry NOT NULL, |
`polygonBackup` polygon DEFAULT NULL, |
`ride_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 soukroma/2 sluzebni' |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='geozone'; |
Attachments
Issue Links
- relates to
-
MDEV-12078 Using spatial index changes type from point to geometry
- Closed