diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/batch_table_io_func.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/batch_table_io_func.result | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/mysql-test/suite/perfschema/r/batch_table_io_func.result b/mysql-test/suite/perfschema/r/batch_table_io_func.result index 212c08c7e90..4336ebd3bd6 100644 --- a/mysql-test/suite/perfschema/r/batch_table_io_func.result +++ b/mysql-test/suite/perfschema/r/batch_table_io_func.result @@ -154,8 +154,8 @@ alter table t3 add index(id2); explain extended select t1.*, t2.*, t3.* from t1 join t2 using (id1) join t3 using (id2); id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t1 ALL id1 NULL NULL NULL 10 100.00 Using where -1 SIMPLE t2 ref id2,id1 id1 5 test.t1.id1 10 100.00 Using where +1 SIMPLE t1 ALL id1 NULL NULL NULL 10 100.00 +1 SIMPLE t2 ALL id2,id1 NULL NULL NULL 100 10.00 Using where; Using join buffer (flat, BNL join) 1 SIMPLE t3 ref id2 id2 5 test.t2.id2 10 100.00 Warnings: Note 1003 select `test`.`t1`.`id1` AS `id1`,`test`.`t1`.`a` AS `a`,`test`.`t2`.`id1` AS `id1`,`test`.`t2`.`id2` AS `id2`,`test`.`t2`.`b` AS `b`,`test`.`t3`.`id2` AS `id2`,`test`.`t3`.`id3` AS `id3`,`test`.`t3`.`c` AS `c` from `test`.`t1` join `test`.`t2` join `test`.`t3` where `test`.`t3`.`id2` = `test`.`t2`.`id2` and `test`.`t2`.`id1` = `test`.`t1`.`id1` @@ -167,7 +167,7 @@ number_seen OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME OPERATION NUMBER_OF 11 TABLE test t1 NULL fetch 1 1 TABLE test t1 id1 read external NULL 1 TABLE test t1 id1 read normal NULL -110 TABLE test t2 id1 fetch 1 +101 TABLE test t2 NULL fetch 1 1 TABLE test t2 id2 read external NULL 1 TABLE test t2 id2 read normal NULL 100 TABLE test t3 id2 fetch 10 @@ -177,14 +177,15 @@ OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME INDEX_NAME COUNT_STAR COUNT_READ COUNT_WRI TABLE test t0 NULL 0 0 0 TABLE test t1 NULL 11 11 0 TABLE test t1 id1 0 0 0 -TABLE test t2 id1 110 110 0 +TABLE test t2 NULL 101 101 0 +TABLE test t2 id1 0 0 0 TABLE test t2 id2 0 0 0 TABLE test t3 id2 1000 1000 0 TABLE test t3 id3 0 0 0 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME COUNT_STAR COUNT_READ COUNT_WRITE TABLE test t0 0 0 0 TABLE test t1 11 11 0 -TABLE test t2 110 110 0 +TABLE test t2 101 101 0 TABLE test t3 1000 1000 0 drop table t0; drop table t1; |