--disable_abort_on_error

--disable_warnings
DROP TABLE IF EXISTS t1, t2, t3;
--enable_warnings

# Attention: The partition gets no storage engine assigned.
let $part1= CREATE TABLE ;
let $part2=  ( f_int1 int(11) default NULL ) ;
let $part3= DEFAULT CHARSET=latin1
PARTITION BY RANGE (f_int1) SUBPARTITION BY HASH (f_int1)
(PARTITION part1 VALUES LESS THAN (1000) ;
let $part4= 
(SUBPARTITION subpart11 ;
let $part5= ));

SET SESSION storage_engine='MEMORY';
#-----------------------------------#

eval $part1 t1 $part2 ENGINE = MEMORY $part3 ENGINE = MEMORY $part4 ENGINE = MEMORY $part5;
# Attention: The partition get no storage engine assigned.
eval $part1 t2 $part2 ENGINE = MEMORY $part3                 $part4 ENGINE = MEMORY $part5;
# Attention: The partition get no storage engine assigned.
eval $part1 t3 $part2 ENGINE = MEMORY $part3                 $part4 ENGINE = MEMORY $part5;

--echo # session default storage engine = MEMORY
--echo # partition has no storage engine assigned, 
--echo # subpartition storage engine = MEMORY assigned, 
--exec ls var/master-data/test/t2*
DROP TABLE t2;


SET SESSION storage_engine='MyISAM';
#-----------------------------------#

--echo # session default storage engine = MyISAM
--echo # partition has no storage engine assigned, 
--echo # subpartition storage engine = MEMORY assigned
--exec ls var/master-data/test/t3*
DROP TABLE t3;

--echo # session default storage engine = MyISAM
--echo # partition storage engine = MEMORY assigned
--echo # subpartition storage engine = MEMORY assigned
--exec ls var/master-data/test/t1*
DROP TABLE t1;