1--source include/have_rocksdb.inc
2--source include/have_partition.inc
3
4# temporarily disable 5.7 full_group_by for test
5--source include/turn_off_only_full_group_by.inc
6
7create table t (
8  a int,
9  b int,
10  c varchar(12249) collate latin1_bin,
11  d datetime,
12  e int,
13  f int,
14  g blob,
15  h int,
16  i int,
17  key (b,e),
18  key (h,b)
19) engine=rocksdb
20partition by linear hash (i) partitions 8;
21
22insert into t values (1,1,'a',now(),1,1,'a',1,1);
23insert into t values (1,1,'a',now(),1,1,'a',1,1);
24insert into t values (1,1,'a',now(),1,1,'a',1,1);
25insert into t values (1,1,'a',now(),1,1,'a',1,1);
26insert into t values (1,1,'a',now(),1,1,'a',1,1);
27insert into t values (1,1,'a',now(),1,1,'a',1,1);
28insert into t values (1,1,'a',now(),1,1,'a',1,1);
29insert into t values (1,1,'a',now(),1,1,'a',1,1);
30select i from t group by h;
31select i from t group by h;
32
33drop table t;
34
35--source include/restore_sql_mode_after_turn_off_only_full_group_by.inc
36