summaryrefslogtreecommitdiff
path: root/mysql-test/r/key_diff.result
diff options
context:
space:
mode:
authorbell@sanja.is.com.ua <>2002-10-03 18:47:04 +0300
committerbell@sanja.is.com.ua <>2002-10-03 18:47:04 +0300
commit2883c3a8cc39446567b8177e1d1a14a3c05d9144 (patch)
treea10d91a6ce2aa4dc6b0104292912675442cafafb /mysql-test/r/key_diff.result
parentc65515d88884ac2617d29eee8158033d60df17cb (diff)
downloadmariadb-git-2883c3a8cc39446567b8177e1d1a14a3c05d9144.tar.gz
fixing EXPLAIN select types
Diffstat (limited to 'mysql-test/r/key_diff.result')
-rw-r--r--mysql-test/r/key_diff.result4
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