33 lines
743 B
Plaintext
33 lines
743 B
Plaintext
drop table if exists t;
|
|
Warnings:
|
|
Note 1051 Unknown table 'test.t'
|
|
create table t (
|
|
a int,
|
|
b int,
|
|
c varchar(12249) collate latin1_bin,
|
|
d datetime,
|
|
e int,
|
|
f int,
|
|
g blob,
|
|
h int,
|
|
i int,
|
|
key (b,e),
|
|
key (h,b)
|
|
) engine=xengine
|
|
partition by linear hash (i) partitions 8 ;
|
|
insert into t values (1,1,'a',now(),1,1,'a',1,1);
|
|
insert into t values (1,1,'a',now(),1,1,'a',1,1);
|
|
insert into t values (1,1,'a',now(),1,1,'a',1,1);
|
|
insert into t values (1,1,'a',now(),1,1,'a',1,1);
|
|
insert into t values (1,1,'a',now(),1,1,'a',1,1);
|
|
insert into t values (1,1,'a',now(),1,1,'a',1,1);
|
|
insert into t values (1,1,'a',now(),1,1,'a',1,1);
|
|
insert into t values (1,1,'a',now(),1,1,'a',1,1);
|
|
select i from t group by h;
|
|
i
|
|
1
|
|
select i from t group by h;
|
|
i
|
|
1
|
|
drop table t;
|