--source include/have_innodb.inc

set global innodb_file_per_table = 1;


connect(con1, localhost, root,,test,,);
connection  con1;

CREATE TABLE `c` (
   `i` bigint(20) NOT NULL,
   `ai` varchar(64) NOT NULL,
   PRIMARY KEY (`ai`,`i`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
PARTITION BY KEY (ai)
PARTITIONS 20;
 
create table t1(f1 int not null auto_increment primary key);
insert into t1 values(null);
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;
insert into t1 select null from t1;

insert into c select f1, concat('0_',f1) from t1;

let $datadir=`select @@datadir`;
--exec ls -lh $datadir/test