问创建有分区的表时会报错：ERROR 1497 (HY000) ？

使用云数据库5.6版本时：

创建有分区的表时会报错：ERROR 1497 (HY000): The mix of handlers in the partitions is not allowed in this version of MySQL

CREATE TABLE `dbtest` (

`id` int(11) NOT NULL,

`u_id` int(11) NOT NULL,

`date` datetime NOT NULL,

PRIMARY KEY (`id`),

KEY `u_id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8

PARTITION BY RANGE (id)

(PARTITION p1 VALUES LESS THAN (1000) ENGINE = MyISAM,

PARTITION p2 VALUES LESS THAN (5000) ENGINE = MyISAM);

但是

CREATE TABLE `dbtest` (

`id` int(11) NOT NULL,

`u_id` int(11) NOT NULL,

`date` datetime NOT NULL,

PRIMARY KEY (`id`),

KEY `u_id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8

PARTITION BY RANGE (id)

(PARTITION p1 VALUES LESS THAN (1000) ,

PARTITION p2 VALUES LESS THAN (5000) );

可以正常创建。这个是什么问题？