diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/cluster_2968-3.result')
| -rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/cluster_2968-3.result | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/cluster_2968-3.result b/storage/tokudb/mysql-test/tokudb/r/cluster_2968-3.result index 660d63c54c8..a36df1f251e 100644 --- a/storage/tokudb/mysql-test/tokudb/r/cluster_2968-3.result +++ b/storage/tokudb/mysql-test/tokudb/r/cluster_2968-3.result @@ -1012,21 +1012,21 @@ 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' show create table u; Table Create Table u CREATE TABLE `u` ( `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,u where s.b = t.b and s.c = t.c; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL NULL NULL NULL NULL 1000 @@ -1042,7 +1042,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` ( @@ -1050,7 +1050,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' show create table u; Table Create Table u CREATE TABLE `u` ( @@ -1058,7 +1058,7 @@ u CREATE TABLE `u` ( `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, KEY `c` (`c`) -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' explain select straight_join * from s,t,u where s.b = t.b and s.c = u.c; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL b NULL NULL NULL 1000 Using where @@ -1081,7 +1081,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` ( @@ -1090,7 +1090,7 @@ 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' show create table u; Table Create Table u CREATE TABLE `u` ( @@ -1099,7 +1099,7 @@ u CREATE TABLE `u` ( `c` int(11) DEFAULT NULL, KEY `c` (`c`), KEY `c_2` (`c`) `clustering`=yes -) ENGINE=TokuDB DEFAULT CHARSET=latin1 +) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib' explain select straight_join * from s,t,u where s.b = t.b and s.c = u.c; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL b,b_2 NULL NULL NULL 1000 Using where |