CREATE .. PARTITION .. AS SELECT creates a partition, but non-partitioned table

--source include/have_partition.inc

--source include/have_sequence.inc

create table t (a int) partition by hash (a) as select seq as a from seq_1_to_10;

show create table t;

select count(*) from information_schema.partitions where table_schema = 'test' and table_name = 't';

select count(*) from t partition (p0);

drop table t;

show create table t;

Table	Create Table

t	CREATE TABLE `t` (

  `a` int(11) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

select count(*) from information_schema.partitions where table_schema = 'test' and table_name = 't';

count(*)

1

mysqltest: At line 8: query 'select count(*) from t partition (p0)' failed: 1747: PARTITION () clause on non partitioned table