diff options
| author | igor@olga.mysql.com <> | 2007-06-03 22:52:02 -0700 |
|---|---|---|
| committer | igor@olga.mysql.com <> | 2007-06-03 22:52:02 -0700 |
| commit | ca49b83d5a3cd1bd0e214f5f3c92772e3849c265 (patch) | |
| tree | 9bfac4f842371d84eebd379e361ab3df1e3bf0f0 /mysql-test/r/key_diff.result | |
| parent | 6044940b258a964e19264e466fd4fd044dc495d3 (diff) | |
| parent | b642eb121f7ca52706191d827595a9ed2538b3be (diff) | |
| download | mariadb-git-ca49b83d5a3cd1bd0e214f5f3c92772e3849c265.tar.gz | |
Merge olga.mysql.com:/home/igor/mysql-5.1
into olga.mysql.com:/home/igor/mysql-5.1-opt-merge
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 35aad39edbf..9d26bee4557 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 SIMPLE t1 ALL a NULL NULL NULL 5 Using join cache -1 SIMPLE t2 ALL b NULL NULL NULL 5 Using where +1 SIMPLE t1 ALL a NULL NULL NULL 5 +1 SIMPLE t2 ALL b NULL NULL NULL 5 Using where; Using join buffer 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 |