use test; drop table if exists t1; create table t1_test(id int not null,name varchar(25),data tinyblob,key(name),key(id)) engine=falcon partition by range(id) ( partition p00 values less than (5000)); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); insert into t1_test values (floor(10000 * rand()),'aaaaaaa','bbbbbbb'); alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08; alter table t1_test add partition (partition `p08` values less than (200000)); alter table t1_test drop partition p08;