--disable_abort_on_error
SET SESSION storage_engine='MyISAM';
SET AUTOCOMMIT= 1;
set @@session.sql_mode= '';
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1 (
 f_int1 INTEGER, f_int2 INTEGER,
 f_char1 CHAR(10), f_char2 CHAR(10), f_charbig VARCHAR(1000)
) PARTITION BY LIST(MOD(f_int1,3)) SUBPARTITION BY HASH(f_int2 + 1)
( PARTITION part1 VALUES IN (-2) (SUBPARTITION sp1, SUBPARTITION sp2),
  PARTITION part2 VALUES IN (-1) (SUBPARTITION sp1, SUBPARTITION sp2),
  PARTITION part3 VALUES IN (0) (SUBPARTITION sp1, SUBPARTITION sp2),
  PARTITION part4 VALUES IN (1) (SUBPARTITION sp1, SUBPARTITION sp2),
  PARTITION part5 VALUES IN (2) (SUBPARTITION sp1, SUBPARTITION sp2));
INSERT INTO t1 SET f_int1 = 2, f_int2 = 2, f_char1 = '2', f_char2 = '2', f_charbig = '===2===';
INSERT INTO t1 SET f_int1 = 2, f_int2 = 2, f_char1 = '2', f_char2 = '2', f_charbig = '===2===';

SELECT * FROM t1 WHERE f_int1  IS NULL;