130
#BUG 18618561: FAILED ALTER TABLE ENGINE CHANGE WITH PARTITIONS
132
CREATE TABLE t1 (fld1 INT PRIMARY KEY) ENGINE= MYISAM PARTITION BY HASH(fld1)
134
SHOW CREATE TABLE t1;
136
t1 CREATE TABLE `t1` (
137
`fld1` int(11) NOT NULL,
139
) ENGINE=MyISAM DEFAULT CHARSET=latin1
140
/*!50100 PARTITION BY HASH (fld1)
142
ALTER TABLE t1 ENGINE= ARCHIVE;
143
ERROR HY000: Can't create table 'test.#sql-temporary' (errno: 1)
144
#After the patch, the ENGINE is correctly displayed as MyISAM
145
SHOW CREATE TABLE t1;
147
t1 CREATE TABLE `t1` (
148
`fld1` int(11) NOT NULL,
150
) ENGINE=MyISAM DEFAULT CHARSET=latin1
151
/*!50100 PARTITION BY HASH (fld1)