diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-10-03 18:47:04 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-10-03 18:47:04 +0300 |
| commit | f094b6af4c5c32bfda7f74461d47675ab61722a0 (patch) | |
| tree | a10d91a6ce2aa4dc6b0104292912675442cafafb /mysql-test/r/heap_hash.result | |
| parent | c9a2b58986635015b3f3867999ef3fafa2bd2728 (diff) | |
| download | mariadb-git-f094b6af4c5c32bfda7f74461d47675ab61722a0.tar.gz | |
fixing EXPLAIN select types
Diffstat (limited to 'mysql-test/r/heap_hash.result')
| -rw-r--r-- | mysql-test/r/heap_hash.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/heap_hash.result b/mysql-test/r/heap_hash.result index 4dd79e5c52b..43a86069d3d 100644 --- a/mysql-test/r/heap_hash.result +++ b/mysql-test/r/heap_hash.result @@ -66,7 +66,7 @@ a alter table t1 type=myisam; explain select * from t1 where a in (869751,736494,226312,802616); id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 range uniq_id uniq_id 4 NULL 4 where used; Using index +1 SIMPLE t1 range uniq_id uniq_id 4 NULL 4 where used; Using index drop table t1; create table t1 (x int not null, y int not null, key x using HASH (x), unique y using HASH (y)) type=heap; @@ -85,8 +85,8 @@ x y x y 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 FIRST t1 ALL x NULL NULL NULL 6 -1 FIRST t2 eq_ref y y 4 t1.x 1 +1 SIMPLE t1 ALL x NULL NULL NULL 6 +1 SIMPLE t2 eq_ref y y 4 t1.x 1 drop table t1; create table t1 (a int) type=heap; insert into t1 values(1); @@ -159,17 +159,17 @@ create table t1 (btn char(10) not null, key using HASH (btn)) type=heap; insert into t1 values ("hello"),("hello"),("hello"),("hello"),("hello"),("a"),("b"),("c"),("d"),("e"),("f"),("g"),("h"),("i"); explain select * from t1 where btn like "q%"; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL btn NULL NULL NULL 14 where used +1 SIMPLE t1 ALL btn NULL NULL NULL 14 where used select * from t1 where btn like "q%"; btn alter table t1 add column new_col char(1) not null, add key using HASH (btn,new_col), drop key btn; update t1 set new_col=btn; explain select * from t1 where btn="a"; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL btn NULL NULL NULL 14 where used +1 SIMPLE t1 ALL btn NULL NULL NULL 14 where used explain select * from t1 where btn="a" and new_col="a"; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ref btn btn 11 const,const 10 where used +1 SIMPLE t1 ref btn btn 11 const,const 10 where used drop table t1; CREATE TABLE t1 ( a int default NULL, @@ -182,7 +182,7 @@ SELECT * FROM t1 WHERE a=NULL; a b explain SELECT * FROM t1 WHERE a IS NULL; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ref a a 5 const 10 where used +1 SIMPLE t1 ref a a 5 const 10 where used SELECT * FROM t1 WHERE a<=>NULL; a b NULL 99 @@ -190,7 +190,7 @@ SELECT * FROM t1 WHERE b=NULL; a b explain SELECT * FROM t1 WHERE b IS NULL; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ref b b 5 const 1 where used +1 SIMPLE t1 ref b b 5 const 1 where used SELECT * FROM t1 WHERE b<=>NULL; a b 99 NULL |