blob: 192e56f10a14f090931ff17158d8589551383714 (
plain)
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
|
--source include/have_tokudb.inc
SET DEFAULT_STORAGE_ENGINE='tokudb';
--echo *** Bug #22169 ***
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
create table t1 (a int, b varchar(20), c int, key (a));
insert into t1 values (1,"10",100);
insert into t1 values (2,"20",200);
insert into t1 values (3,"30",300);
insert into t1 values (4,"40",400);
insert into t1 values (5,"50",500);
explain select * from t1 where a > 2;
select * from t1 where a > 2;
select b from t1 where a > 2;
select c from t1 where a > 2;
#explain delete from t1 where a <2;
delete from t1 where a <2;
explain select * from t1 where a >= 4;
select * from t1 where a >= 4;
select b from t1 where a >= 4;
select c from t1 where a >= 4;
update t1 set c = c+1000;
explain select * from t1 where a >= 4;
select * from t1 where a >= 4;
select b from t1 where a >= 4;
select c from t1 where a >= 4;
DROP TABLE t1;
|
