Bug #84362 PARTITION BY LIST COLUMNS allows unsupported data types
Submitted: 28 Dec 2016 17:11 Modified: 28 Dec 2016 17:51
Reporter: Elena Stepanova Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.6, 5.7,8.0 OS:Any
Assigned to: CPU Architecture:Any

[28 Dec 2016 17:11] Elena Stepanova
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));
[28 Dec 2016 17:51] MySQL Verification Team
Thank you for the bug report. Verified as described.