diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/cluster_2968-1.result')
| -rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/cluster_2968-1.result | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/cluster_2968-1.result b/storage/tokudb/mysql-test/tokudb/r/cluster_2968-1.result index c23f71f28f0..b124834f7c8 100644 --- a/storage/tokudb/mysql-test/tokudb/r/cluster_2968-1.result +++ b/storage/tokudb/mysql-test/tokudb/r/cluster_2968-1.result @@ -1009,14 +1009,14 @@ s CREATE TABLE `s` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' show create table t; Table Create Table t CREATE TABLE `t` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' explain select straight_join * from s,t where s.b = t.b; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL NULL NULL NULL NULL 1000 @@ -1030,7 +1030,7 @@ s CREATE TABLE `s` ( `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, KEY `b` (`b`) -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' show create table t; Table Create Table t CREATE TABLE `t` ( @@ -1038,7 +1038,7 @@ t CREATE TABLE `t` ( `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, KEY `b` (`b`) -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' explain select straight_join * from s,t where s.b = t.b; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL b NULL NULL NULL 1000 Using where @@ -1057,7 +1057,7 @@ s CREATE TABLE `s` ( `c` int(11) DEFAULT NULL, KEY `b` (`b`), KEY `b_2` (`b`) `clustering`=yes -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' show create table t; Table Create Table t CREATE TABLE `t` ( @@ -1066,11 +1066,11 @@ t CREATE TABLE `t` ( `c` int(11) DEFAULT NULL, KEY `b` (`b`), KEY `b_2` (`b`) `clustering`=yes -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' explain select straight_join * from s,t where s.b = t.b; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s index b,b_2 b_2 5 NULL 1000 Using where; Using index -1 SIMPLE t ref b,b_2 b_2 5 test.s.b 11 Using index +1 SIMPLE t ref b,b_2 b_2 5 test.s.b 1 Using index alter table s drop key b; alter table t drop key b; show create table s; @@ -1080,7 +1080,7 @@ s CREATE TABLE `s` ( `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, KEY `b_2` (`b`) `clustering`=yes -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' show create table t; Table Create Table t CREATE TABLE `t` ( @@ -1088,7 +1088,7 @@ t CREATE TABLE `t` ( `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, KEY `b_2` (`b`) `clustering`=yes -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' explain select straight_join * from s,t where s.b = t.b; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s index b_2 b_2 5 NULL 1000 Using where; Using index @@ -1107,7 +1107,7 @@ s CREATE TABLE `s` ( `c` int(11) DEFAULT NULL, KEY `b_2` (`b`) `clustering`=yes, KEY `b` (`b`) -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' show create table t; Table Create Table t CREATE TABLE `t` ( @@ -1116,9 +1116,9 @@ t CREATE TABLE `t` ( `c` int(11) DEFAULT NULL, KEY `b_2` (`b`) `clustering`=yes, KEY `b` (`b`) -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' explain select straight_join * from s,t where s.b = t.b; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s index b_2,b b_2 5 NULL 1000 Using where; Using index -1 SIMPLE t ref b_2,b b_2 5 test.s.b 11 Using index +1 SIMPLE t ref b_2,b b 5 test.s.b 1 drop table s,t; |