mirror of
https://github.com/MariaDB/server.git
synced 2025-08-29 22:01:36 +02:00
30 lines
700 B
Text
30 lines
700 B
Text
drop table if exists 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=rocksdb
|
|
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;
|