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/key_diff.result | |
| parent | c9a2b58986635015b3f3867999ef3fafa2bd2728 (diff) | |
| download | mariadb-git-f094b6af4c5c32bfda7f74461d47675ab61722a0.tar.gz | |
fixing EXPLAIN select types
Diffstat (limited to 'mysql-test/r/key_diff.result')
| -rw-r--r-- | mysql-test/r/key_diff.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/key_diff.result b/mysql-test/r/key_diff.result index 85d1f455b3f..bdeff4f60d8 100644 --- a/mysql-test/r/key_diff.result +++ b/mysql-test/r/key_diff.result @@ -35,8 +35,8 @@ D E a a a a a a explain select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B; id select_type table type possible_keys key key_len ref rows Extra -1 FIRST t1 ALL a NULL NULL NULL 5 -1 FIRST t2 ALL b NULL NULL NULL 5 where used +1 SIMPLE t1 ALL a NULL NULL NULL 5 +1 SIMPLE t2 ALL b NULL NULL NULL 5 where used select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by binary t1.a,t2.a; a b a b A B a a |