diff options
| author | gkodinov/kgeorge@macbook.gmz <> | 2007-05-29 15:58:18 +0300 |
|---|---|---|
| committer | gkodinov/kgeorge@macbook.gmz <> | 2007-05-29 15:58:18 +0300 |
| commit | fe03f6bbe0062c5055037b42de80337cbb14d8a3 (patch) | |
| tree | 291ba8febbc6342a44e7c4737f26f91f2dd1022c /mysql-test/r/view.result | |
| parent | ad5dede76554aa4170857a490669a37154d065cc (diff) | |
| download | mariadb-git-fe03f6bbe0062c5055037b42de80337cbb14d8a3.tar.gz | |
Bug #27531: 5.1 part of the fix
- Renamed "Using join cache" to "Using join buffer".
- "Using join buffer" is now printed on the last
table that "reads" from the join buffer cache.
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index db488aa4876..21dd5330945 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -2317,8 +2317,8 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ref a a 10 const,test.t1.b 2 Using where; Using index EXPLAIN SELECT * FROM v2 WHERE a=1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref a a 5 const 1 Using where; Using index; Using join cache -1 SIMPLE t3 ALL NULL NULL NULL NULL 3 Using where +1 SIMPLE t1 ref a a 5 const 1 Using where; Using index +1 SIMPLE t3 ALL NULL NULL NULL NULL 3 Using where; Using join buffer DROP VIEW v1,v2; DROP TABLE t1,t2,t3; create table t1 (f1 int); |