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)