SET DEFAULT_STORAGE_ENGINE='tokudb';
DROP TABLE IF EXISTS t1;
create table t1(a int, b int, c int, d int, primary key(a), clustering key(b), key (c))engine=tokudb;
insert into t1 values (1,10,100,1000),(2,20,200,2000),(3,30,300,3000),(4,40,400,4000),(5,50,500,5000),(6,60,600,6000),(7,70,700,7000),(8,80,800,8000),(9,90,900,9000);
explain select * from t1 where a > 5;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	NULL;	Using where
select * from t1 where a > 5;
a	b	c	d
6	60	600	6000
7	70	700	7000
8	80	800	8000
9	90	900	9000
explain select * from t1 where b > 30;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	b	b	5	NULL	NULL;	Using where
select * from t1 where b > 30;
a	b	c	d
4	40	400	4000
5	50	500	5000
6	60	600	6000
7	70	700	7000
8	80	800	8000
9	90	900	9000
explain select * from t1 where c > 750;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	c	c	5	NULL	NULL;	Using where
select * from t1 where c > 750;
a	b	c	d
8	80	800	8000
9	90	900	9000
explain select a from t1 where a > 8;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	NULL;	Using where; Using index
select a from t1 where a > 8;
a
9
explain select a,b from t1 where b > 30;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	b	b	5	NULL	NULL;	Using where; Using index
select a,b from t1 where b > 30;
a	b
4	40
5	50
6	60
7	70
8	80
9	90
explain select a,b from t1 where c > 750;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	c	c	5	NULL	NULL;	Using where
select a,c from t1 where c > 750;
a	c
8	800
9	900
delete from t1 where b>30 and b < 60;
select * from t1;
a	b	c	d
1	10	100	1000
2	20	200	2000
3	30	300	3000
6	60	600	6000
7	70	700	7000
8	80	800	8000
9	90	900	9000
explain select * from t1 where a > 5;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	NULL;	Using where
select * from t1 where a > 5;
a	b	c	d
6	60	600	6000
7	70	700	7000
8	80	800	8000
9	90	900	9000
explain select * from t1 where b > 30;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	b	b	5	NULL	NULL;	Using where
select * from t1 where b > 30;
a	b	c	d
6	60	600	6000
7	70	700	7000
8	80	800	8000
9	90	900	9000
explain select * from t1 where c > 750;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	c	c	5	NULL	NULL;	Using where
select * from t1 where c > 750;
a	b	c	d
8	80	800	8000
9	90	900	9000
explain select a from t1 where a > 8;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	NULL;	Using where; Using index
select a from t1 where a > 8;
a
9
explain select a,b from t1 where b > 30;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	b	b	5	NULL	NULL;	Using where; Using index
select a,b from t1 where b > 30;
a	b
6	60
7	70
8	80
9	90
explain select a,b from t1 where c > 750;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	c	c	5	NULL	NULL;	Using where
select a,c from t1 where c > 750;
a	c
8	800
9	900
alter table t1 drop primary key;
explain select * from t1 where a > 5;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	NULL;	Using where
select * from t1 where a > 5;
a	b	c	d
6	60	600	6000
7	70	700	7000
8	80	800	8000
9	90	900	9000
explain select * from t1 where b > 30;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	b	b	5	NULL	NULL;	Using where
select * from t1 where b > 30;
a	b	c	d
6	60	600	6000
7	70	700	7000
8	80	800	8000
9	90	900	9000
explain select * from t1 where c > 750;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	c	c	5	NULL	NULL;	Using where
select * from t1 where c > 750;
a	b	c	d
8	80	800	8000
9	90	900	9000
explain select a from t1 where a > 5;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	NULL;	Using where
select a from t1 where a > 5;
a
6
7
8
9
explain select a,b from t1 where b > 30;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	b	b	5	NULL	NULL;	Using where
select a,b from t1 where b > 30;
a	b
6	60
7	70
8	80
9	90
explain select a,b from t1 where c > 750;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	c	c	5	NULL	NULL;	Using where
select a,c from t1 where c > 750;
a	c
8	800
9	900
delete from t1 where b > 10 and b < 90;
select * from t1;
a	b	c	d
1	10	100	1000
9	90	900	9000
explain select * from t1 where a > 5;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	NULL;	Using where
select * from t1 where a > 5;
a	b	c	d
9	90	900	9000
explain select * from t1 where b > 30;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	b	b	5	NULL	NULL;	Using where
select * from t1 where b > 30;
a	b	c	d
9	90	900	9000
explain select * from t1 where c > 750;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	c	NULL	NULL	NULL	NULL;	Using where
select * from t1 where c > 750;
a	b	c	d
9	90	900	9000
explain select a from t1 where a > 5;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	NULL;	Using where
select a from t1 where a > 5;
a
9
explain select a,b from t1 where b > 30;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	b	b	5	NULL	NULL;	Using where
select a,b from t1 where b > 30;
a	b
9	90
explain select a,b from t1 where c > 750;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	c	NULL	NULL	NULL	NULL;	Using where
select a,c from t1 where c > 750;
a	c
9	900
drop table t1;