let $column_list= f1 int,
f2 char (15),
f3 decimal (5,3),
f4 datetime;

#--------------------------------------------------
# initialize directories for partitions
#--------------------------------------------------

--disable_query_log
# DATA DIRECTORY
# Make directory for partition data
--exec mkdir $MYSQLTEST_VARDIR/master-data/tmpdata || true
eval SET @data_dir = 'DATA DIRECTORY =
''$MYSQLTEST_VARDIR/master-data/tmpdata''';
let $data_directory = `select @data_dir`;

#INDEX DIRECTORY
# Make directory for partition index
--exec mkdir $MYSQLTEST_VARDIR/master-data/tmpindex || true
eval SET @indx_dir = 'INDEX DIRECTORY =
''$MYSQLTEST_VARDIR/master-data/tmpindex''';
let $index_directory = `select @indx_dir`;
--enable_query_log

eval create table tb5_eng1 (
f1 int,
f2 char (15),
f3 decimal (5,3),
f4 datetime) engine=myisam
PARTITION BY LIST (f1)
SUBPARTITION BY HASH (f1)
(PARTITION part1 VALUES in(1,2,3,4) $data_directory $index_directory
(SUBPARTITION subpart11, SUBPARTITION subpart12),
PARTITION part2 VALUES in (5,6,7,8) $data_directory $index_directory
(SUBPARTITION subpart21, SUBPARTITION subpart22),
PARTITION part3 VALUES in (9,10,11,12) $data_directory $index_directory
(SUBPARTITION subpart31, SUBPARTITION subpart32),
PARTITION part4 VALUES in (13,14,15,16) $data_directory $index_directory
(SUBPARTITION subpart41, SUBPARTITION subpart42)
);

eval ALTER TABLE tb5_eng1 REORGANIZE PARTITION part2 INTO
 (PARTITION part8 values in (5,6) $data_directory $index_directory (SUBPARTITION subpart81, SUBPARTITION subpart82),
  PARTITION part9 values in (7,8) $data_directory $index_directory (SUBPARTITION subpart91, SUBPARTITION subpart92));

eval ALTER TABLE tb5_eng1 REORGANIZE PARTITION part8,part9 INTO
 (PARTITION part2 values in (5,6,7,8) $data_directory $index_directory 
(SUBPARTITION subpart21, SUBPARTITION subpart22));