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/myisam.result | |
parent | c9a2b58986635015b3f3867999ef3fafa2bd2728 (diff) | |
download | mariadb-git-f094b6af4c5c32bfda7f74461d47675ab61722a0.tar.gz |
fixing EXPLAIN select types
Diffstat (limited to 'mysql-test/r/myisam.result')
-rw-r--r-- | mysql-test/r/myisam.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 647fe70b694..4b4a88a54f7 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -52,26 +52,26 @@ create table t1 (a int not null, b int not null, c int not null, primary key (a) insert into t1 values (3,3,3),(1,1,1),(2,2,2),(4,4,4); explain select * from t1 order by a; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL NULL NULL NULL NULL 4 Using filesort +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using filesort explain select * from t1 order by b; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL NULL NULL NULL NULL 4 Using filesort +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using filesort explain select * from t1 order by c; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL NULL NULL NULL NULL 4 Using filesort +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using filesort explain select a from t1 order by a; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 index NULL PRIMARY 4 NULL 4 Using index +1 SIMPLE t1 index NULL PRIMARY 4 NULL 4 Using index explain select b from t1 order by b; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 index NULL b 4 NULL 4 Using index +1 SIMPLE t1 index NULL b 4 NULL 4 Using index explain select a,b from t1 order by b; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL NULL NULL NULL NULL 4 Using filesort +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using filesort explain select a,b from t1; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL NULL NULL NULL NULL 4 +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 explain select a,b,c from t1; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL NULL NULL NULL NULL 4 +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 drop table t1; |