1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
|
SET DEFAULT_STORAGE_ENGINE='tokudb';
*** Bug #22169 ***
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a int, b int, c int, z int, y int, x int, r int, s int, t int, primary key (a,b), key (z), key(x), key(t));
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 index NULL foo 10 NULL 10 Using index
c z a b
0 100 10 0
2 90 9 1
4 80 8 2
6 70 7 3
8 60 6 4
10 50 5 5
12 40 4 6
14 30 3 7
16 20 2 8
18 10 1 9
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 10
a b c z y x r s t
1 9 18 10 100 1000 2 3 4
2 8 16 20 200 2000 4 6 8
3 7 14 30 300 3000 6 9 12
4 6 12 40 400 4000 8 12 16
5 5 10 50 500 5000 10 15 20
6 4 8 60 600 6000 12 18 24
7 3 6 70 700 7000 14 21 28
8 2 4 80 800 8000 16 24 32
9 1 2 90 900 9000 18 27 36
10 0 0 100 1000 10000 20 30 40
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 index NULL bar 10 NULL 10 Using index
t r a b
4 2 1 9
8 4 2 8
12 6 3 7
16 8 4 6
20 10 5 5
24 12 6 4
28 14 7 3
32 16 8 2
36 18 9 1
40 20 10 0
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 10
a b c z y x r s t
1 9 18 10 100 1000 2 3 4
2 8 16 20 200 2000 4 6 8
3 7 14 30 300 3000 6 9 12
4 6 12 40 400 4000 8 12 16
5 5 10 50 500 5000 10 15 20
6 4 8 60 600 6000 12 18 24
7 3 6 70 700 7000 14 21 28
8 2 4 80 800 8000 16 24 32
9 1 2 90 900 9000 18 27 36
10 0 0 100 1000 10000 20 30 40
|