diff options
Diffstat (limited to 'mysql-test/suite/heap/heap_btree.result')
| -rw-r--r-- | mysql-test/suite/heap/heap_btree.result | 8 |
1 files changed, 4 insertions, 4 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); |