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/explain.result | |
| parent | c9a2b58986635015b3f3867999ef3fafa2bd2728 (diff) | |
| download | mariadb-git-f094b6af4c5c32bfda7f74461d47675ab61722a0.tar.gz | |
fixing EXPLAIN select types
Diffstat (limited to 'mysql-test/r/explain.result')
| -rw-r--r-- | mysql-test/r/explain.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result index cd0ddeae120..0d97aeaf531 100644 --- a/mysql-test/r/explain.result +++ b/mysql-test/r/explain.result @@ -10,16 +10,16 @@ id str 3 foo explain select * from t1 where str is null; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ref str str 11 const 1 where used +1 SIMPLE t1 ref str str 11 const 1 where used explain select * from t1 where str="foo"; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 const str str 11 const 1 +1 SIMPLE t1 const str str 11 const 1 explain select * from t1 ignore key (str) where str="foo"; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL NULL NULL NULL NULL 4 where used +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 where used explain select * from t1 use key (str,str) where str="foo"; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 const str str 11 const 1 +1 SIMPLE t1 const str str 11 const 1 explain select * from t1 use key (str,str,foo) where str="foo"; Key column 'foo' doesn't exist in table explain select * from t1 ignore key (str,str,foo) where str="foo"; @@ -27,4 +27,4 @@ Key column 'foo' doesn't exist in table drop table t1; explain select 1; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST No tables used +1 SIMPLE No tables used |