# The server must support partitioning.
--source include/have_partition.inc

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1 (f_int1 INTEGER) PARTITION BY RANGE(f_int1)
(PARTITION p1 VALUES LESS THAN (0), PARTITION p2 VALUES LESS THAN (10));

INSERT INTO t1 SET f_int1 = NULL ;
SELECT * FROM t1;
SELECT * FROM t1 WHERE f_int1 IS NULL;

DROP TABLE t1;

CREATE TABLE t1 (f_int1 INTEGER) PARTITION BY LIST(f_int1)
(PARTITION p1 VALUES IN (0), PARTITION p2 VALUES IN (NULL));

INSERT INTO t1 SET f_int1 = NULL ;
SELECT * FROM t1;
SELECT * FROM t1 WHERE f_int1 IS NULL;