Partition by range for float data type column float(12,9) in mysql server 5.6

[esha sethi]

Hello All,

Unable to create partition by range for float data type column float(12,9) in mysql server 5.6


CREATE TABLE `tbl_geodata1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`geo_street` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
`geo_town` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
`geo_country` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
`gps_latitude` float(12,9) NOT NULL,
`gps_longitude` float(12,9) NOT NULL,
`modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `unq_lat_long` (`gps_latitude`,`gps_longitude`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8
partition by range (gps_latitude)(
partition p1 values less than (50)
partition p2 values less than (100));


ERROR:

Sql Execution error#1659 . Response from the database:

Field 'gps_latitude' is of a not allowed type for this type of partitioning.

Please help