EVOLUTION-MANAGER

Edit File: add_index_5.result

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	NULL	foo	foo	NULL	NULL	NULL;	Using where; Using index
c	r	a	b
0	20	10	0
2	18	9	1
4	16	8	2
6	14	7	3
8	12	6	4
10	10	5	5
12	8	4	6
14	6	3	7
16	4	2	8
18	2	1	9
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	NULL	NULL	NULL	NULL	NULL	NULL;	
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	NULL	NULL	NULL	NULL	NULL	NULL;	Using where
c	r	a	b
18	2	1	9
16	4	2	8
14	6	3	7
12	8	4	6
10	10	5	5
8	12	6	4
6	14	7	3
4	16	8	2
2	18	9	1
0	20	10	0
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	NULL	NULL	NULL	NULL	NULL	NULL;	
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	NULL	foo	foo	NULL	NULL	NULL;	Using where; Using index
c	r	a	b
0	20	10	0
2	18	9	1
4	16	8	2
6	14	7	3
8	12	6	4
10	10	5	5
12	8	4	6
14	6	3	7
16	4	2	8
18	2	1	9
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	NULL	NULL	NULL	NULL	NULL	NULL;	
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
ERROR 42000: Duplicate key name 'foo'
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	NULL	foo	foo	NULL	NULL	NULL;	Using where; Using index
c	r	a	b
0	20	10	0
2	18	9	1
4	16	8	2
6	14	7	3
8	12	6	4
10	10	5	5
12	8	4	6
14	6	3	7
16	4	2	8
18	2	1	9
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	NULL	NULL	NULL	NULL	NULL	NULL;	
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	NULL	z	z	NULL	NULL	NULL;	Using where; Using index
z	a	b
10	1	9
20	2	8
30	3	7
40	4	6
50	5	5
60	6	4
70	7	3
80	8	2
90	9	1
100	10	0
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	NULL	NULL	NULL	NULL	NULL	NULL;	
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	NULL	foo	foo	NULL	NULL	NULL;	Using where; Using index
c	r	a	b
0	20	10	0
2	18	9	1
4	16	8	2
6	14	7	3
8	12	6	4
10	10	5	5
12	8	4	6
14	6	3	7
16	4	2	8
18	2	1	9
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	NULL	NULL	NULL	NULL	NULL	NULL;	
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