DROP TABLE IF EXISTS t1, t2, t3;
SET SESSION storage_engine='MEMORY';
CREATE TABLE  t1 ( f_int1 int(11) default NULL )  ENGINE = MEMORY DEFAULT CHARSET=latin1
PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int1)
(PARTITION part1 VALUES LESS THAN (1000)  ENGINE = MEMORY (SUBPARTITION subpart11  ENGINE = MEMORY ));
CREATE TABLE  t2 ( f_int1 int(11) default NULL )  ENGINE = MEMORY DEFAULT CHARSET=latin1
PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int1)
(PARTITION part1 VALUES LESS THAN (1000)                  (SUBPARTITION subpart11  ENGINE = MEMORY ));
CREATE TABLE  t3 ( f_int1 int(11) default NULL )  ENGINE = MEMORY DEFAULT CHARSET=latin1
PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int1)
(PARTITION part1 VALUES LESS THAN (1000)                  (SUBPARTITION subpart11  ENGINE = MEMORY ));
# session default storage engine = MEMORY
# partition has no storage engine assigned, 
# subpartition storage engine = MEMORY assigned, 
var/master-data/test/t2.frm
var/master-data/test/t2.par
DROP TABLE t2;
SET SESSION storage_engine='MyISAM';
# session default storage engine = MyISAM
# partition has no storage engine assigned, 
# subpartition storage engine = MEMORY assigned
var/master-data/test/t3.frm
var/master-data/test/t3.par
DROP TABLE t3;
ERROR HY000: Error on delete of './test/t3#P#part1#SP#subpart11.MYI' (Errcode: 2)
# session default storage engine = MyISAM
# partition storage engine = MEMORY assigned
# subpartition storage engine = MEMORY assigned
var/master-data/test/t1.frm
var/master-data/test/t1.par
DROP TABLE t1;