diff options
Diffstat (limited to 'mysql-test/suite/heap')
| -rw-r--r-- | mysql-test/suite/heap/heap_btree.result | 8 | ||||
| -rw-r--r-- | mysql-test/suite/heap/heap_hash.result | 6 |
2 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/suite/heap/heap_btree.result b/mysql-test/suite/heap/heap_btree.result index 12a011778c6..6e681466408 100644 --- a/mysql-test/suite/heap/heap_btree.result +++ b/mysql-test/suite/heap/heap_btree.result @@ -73,7 +73,7 @@ engine=heap; insert into t1 values (1,1),(2,2),(1,3),(2,4),(2,5),(2,6); explain select * from t1 where x=1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref x x 4 const 1 +1 SIMPLE t1 ref x x 4 const 1 Using where select * from t1 where x=1; x y 1 1 @@ -81,15 +81,15 @@ x y select * from t1,t1 as t2 where t1.x=t2.y; x y x y 1 1 1 1 -2 2 2 2 1 3 1 1 +2 2 2 2 2 4 2 2 2 5 2 2 2 6 2 2 explain select * from t1,t1 as t2 where t1.x=t2.y; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL x NULL NULL NULL 6 -1 SIMPLE t2 eq_ref y y 4 test.t1.x 1 +1 SIMPLE t2 hash_ALL y #hash#y 4 test.t1.x 6 Using join buffer (flat, BNLH join) drop table t1; create table t1 (a int) engine=heap; insert into t1 values(1); @@ -134,7 +134,7 @@ a b 1 1 explain select * from tx where b=x; id select_type table type possible_keys key key_len ref rows Extra -x SIMPLE tx ref b b x const x +x SIMPLE tx ref b b x const x Using where drop table t1; create table t1 (id int unsigned not null, primary key using BTREE (id)) engine=HEAP; insert into t1 values(1); diff --git a/mysql-test/suite/heap/heap_hash.result b/mysql-test/suite/heap/heap_hash.result index 55d43588403..f9b7025eded 100644 --- a/mysql-test/suite/heap/heap_hash.result +++ b/mysql-test/suite/heap/heap_hash.result @@ -78,15 +78,15 @@ x y select * from t1,t1 as t2 where t1.x=t2.y; x y x y 1 1 1 1 -2 2 2 2 1 3 1 1 +2 2 2 2 2 4 2 2 2 5 2 2 2 6 2 2 explain select * from t1,t1 as t2 where t1.x=t2.y; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL x NULL NULL NULL 6 -1 SIMPLE t2 eq_ref y y 4 test.t1.x 1 +1 SIMPLE t2 hash_ALL y #hash#y 4 test.t1.x 6 Using join buffer (flat, BNLH join) drop table t1; create table t1 (a int) engine=heap; insert into t1 values(1); @@ -354,7 +354,7 @@ t3 1 a 2 b NULL 13 NULL NULL HASH explain select * from t1 ignore key(btree_idx), t3 where t1.name='matt' and t3.a = concat('',t1.name) and t3.b=t1.name; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref heap_idx heap_idx 22 const 7 Using where -1 SIMPLE t3 ref a a 44 func,const 7 Using where +1 SIMPLE t3 hash_ALL a #hash#a 44 func,const 91 Using where; Using join buffer (flat, BNLH join) drop table t1, t2, t3; create temporary table t1 ( a int, index (a) ) engine=memory; insert into t1 values (1),(2),(3),(4),(5); |