Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.2
Description
According to the manual, float and some other data types are not supported:
http://dev.mysql.com/doc/refman/5.6/en/partitioning-columns.html
CREATE TABLE t1 (f float) PARTITION BY LIST COLUMNS (f) (PARTITION pnull VALUES IN (NULL)); |
MariaDB [test]> CREATE TABLE t1 (f float) PARTITION BY LIST COLUMNS (f) (PARTITION pnull VALUES IN (NULL)); |
Query OK, 0 rows affected (0.40 sec) |
|
MariaDB [test]> show create table t1 \G |
*************************** 1. row ***************************
|
Table: t1 |
Create Table: CREATE TABLE `t1` ( |
`f` float DEFAULT NULL |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
PARTITION BY LIST COLUMNS(f) |
(PARTITION pnull VALUES IN (NULL) ENGINE = InnoDB) |
1 row in set (0.00 sec) |
|
MariaDB [test]> insert into t1 values (null); |
Query OK, 1 row affected (0.10 sec)
|
Same for some other data types.