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