Description:
Documentation explicitly lists data types supported and not supported by column partitioning:
http://dev.mysql.com/doc/refman/5.6/en/partitioning-columns.html
<quote>
Other numeric data types (such as DECIMAL or FLOAT) are not supported as partitioning columns.
</quote>
However, it is possible to create a partition with an unsupported data type:
MySQL [test]> CREATE TABLE t1 (f float) PARTITION BY LIST COLUMNS (f) (PARTITION pnull VALUES IN (NULL));
Query OK, 0 rows affected (0.44 sec)
MySQL [test]> SHOW CREATE TABLE t1 \G
*************************** 1. row ***************************
Table: t1
Create Table: CREATE TABLE `t1` (
`f` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50500 PARTITION BY LIST COLUMNS(f)
(PARTITION pnull VALUES IN (NULL) ENGINE = InnoDB) */
1 row in set (0.01 sec)
MySQL [test]> INSERT INTO t1 VALUES (NULL);
Query OK, 1 row affected (0.04 sec)
Same is true for other data types.
How to repeat:
CREATE TABLE t1 (f float) PARTITION BY LIST COLUMNS (f) (PARTITION pnull VALUES IN (NULL));