1SET DEFAULT_STORAGE_ENGINE='tokudb'; 2*** Bug #22169 *** 3DROP TABLE IF EXISTS z1; 4create table z1 (a int, b int, c int, d int, e int, key (a) clustering=yes); 5insert into z1 values (1,1,1,1,1),(7,7,7,7,7),(4,4,4,4,4),(3,3,3,3,3),(5,5,5,5,5),(2,2,2,2,2),(6,6,6,6,6); 6explain select * From z1 order by a; 7id select_type table type possible_keys key key_len ref rows Extra 81 SIMPLE z1 index NULL a 5 NULL 7 Using index 9select * from z1 order by a; 10a b c d e 111 1 1 1 1 122 2 2 2 2 133 3 3 3 3 144 4 4 4 4 155 5 5 5 5 166 6 6 6 6 177 7 7 7 7 18explain select * From z1 order by a desc; 19id select_type table type possible_keys key key_len ref rows Extra 201 SIMPLE z1 index NULL a 5 NULL 7 Using index 21select * from z1 order by a desc; 22a b c d e 237 7 7 7 7 246 6 6 6 6 255 5 5 5 5 264 4 4 4 4 273 3 3 3 3 282 2 2 2 2 291 1 1 1 1 30DROP TABLE z1; 31