--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,2)) SUBPARTITION BY KEY(f_int1) (
 PARTITION part1 VALUES IN (-1) (SUBPARTITION sp1, SUBPARTITION sp2),
 PARTITION part2 VALUES IN (0) (SUBPARTITION sp1, SUBPARTITION sp2),
 PARTITION part3 VALUES IN (1) (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;